Search found 53125 matches

by ray.wurlod
Thu Jul 05, 2007 1:38 pm
Forum: General
Topic: Probelm regarding Jobsequencer.
Replies: 9
Views: 2855

And what's the command?
Maybe you need DIGITS(CommandActivity.$CommandOutput) and/or to strip field marks from the command output.
by ray.wurlod
Thu Jul 05, 2007 1:36 pm
Forum: General
Topic: Server to Parallel Transition Lab
Replies: 3
Views: 1166

I mean specifically the class Server to Parallel Transition Lab - there is a need to communicate with graduates about such issues as server down-time (when another class is running) and so on.
by ray.wurlod
Thu Jul 05, 2007 1:05 pm
Forum: General
Topic: Server to Parallel Transition Lab
Replies: 3
Views: 1166

Server to Parallel Transition Lab

If you have already attended one of these please send me an email or a PM. We have finally created the promised Forum on DSXchange, but you need to be a "graduate" to be able to see it. As I'm the moderator it's me who gets you registered to that forum.
by ray.wurlod
Thu Jul 05, 2007 1:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TRIM(varchar(50)) not working
Replies: 15
Views: 9287

If this is in a constraint expression, lose the IF

Code: Select all

Len(Convert(" ", "", NullToValue(InLink.TheColumn, " "))) > 0
will suffice as a constraint expression
by ray.wurlod
Thu Jul 05, 2007 1:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: mkdbfile returnd error code 1
Replies: 8
Views: 1302

Why not the following?

Code: Select all

cd ${PWDER} 
. ${DSHOME}/dsenv
${DSHOME}/bin/mkdbfile ...
by ray.wurlod
Thu Jul 05, 2007 12:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sysbase Metadata import Error
Replies: 5
Views: 1289

Have you searched for "unable to initialize plugin"?
by ray.wurlod
Thu Jul 05, 2007 11:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: mkdbfile returnd error code 1
Replies: 8
Views: 1302

What's changed? "Nothing" is not the correct answer.
by ray.wurlod
Thu Jul 05, 2007 11:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How do to add a line for each value in the Column
Replies: 11
Views: 3188

Simply parse these data into separate columns. Use a Transformer stage with Field() functions or a Column Import stage.
by ray.wurlod
Thu Jul 05, 2007 11:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Get the stage name in all jobs
Replies: 4
Views: 1452

Suspect job name is also required, so a join to DS_JOBS is needed. SELECT BREAK ON "'O'" DS_JOBS.NAME JobName, DS_JOBOBJECTS.NAME StageName FMT '48L' FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO AND DS_JOBOBJECTS.OLETYPE LIKE '%Stage%' ORDER BY 1, 2 ;
by ray.wurlod
Thu Jul 05, 2007 11:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TRIM(varchar(50)) not working
Replies: 15
Views: 9287

Code: Select all

If Len(Convert(" ", "", NullToValue(InLink.TheColumn, " "))) > 0 ...
by ray.wurlod
Thu Jul 05, 2007 11:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Adding Months to theExisting Months
Replies: 3
Views: 1588

Download date routines from my website and use the AddMonths routine.
by ray.wurlod
Thu Jul 05, 2007 11:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Waiting for File
Replies: 6
Views: 2013

:oops:

Look at the generated Job Control code
by ray.wurlod
Thu Jul 05, 2007 11:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How do to add a line for each value in the Column
Replies: 11
Views: 3188

One of the examples in the manual (Pivot.pdf) is almost exactly your scenario.
by ray.wurlod
Thu Jul 05, 2007 11:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null Handling
Replies: 16
Views: 4485

There's nothing really premium about the content, which is why I disabled the Premium flag. Ordinarily I would not do so.
by ray.wurlod
Thu Jul 05, 2007 11:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: mkdbfile returnd error code 1
Replies: 8
Views: 1302

You got something wrong with the syntax, or you don't have write permission to the directory where you're trying to create it. Check you syntax with Hashed File Calculator (you can copy the command from there and paste it in to your shell).