Search found 53125 matches

by ray.wurlod
Wed Sep 24, 2008 4:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Routine Calls
Replies: 15
Views: 4271

All of a minute ago!
:wink:
by ray.wurlod
Wed Sep 24, 2008 4:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Routine Calls
Replies: 15
Views: 4271

STOP thinking in C programming terms. There is NO zero element here. It's a string! It's a string delimited by space characters. ScriptPath = Field(InputArg, " ", 1, 1) DatabaseName = Field(InputArg, " ", 2, 1) UserID = Field(InputArg, " ", 3, 1)...
by ray.wurlod
Wed Sep 24, 2008 3:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Routine Calls
Replies: 15
Views: 4271

This is not C. InputArg is not an array. It is a string.

Therefore InputArg(0) is not a valid construct (unless there is a DIMENSION or COMMON declaration that you've hidden from us).

Please post the detail of what gets logged by the first two calls to DSLogInfo() in RoutineB.
by ray.wurlod
Wed Sep 24, 2008 2:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job aborts abnormally
Replies: 2
Views: 1152

Moderator: please move to parallel forum

Please do not post in the wrong forum; it's annoying and wastes time trying to get it right. Server job answers to parallel job questions don't help anyone.
by ray.wurlod
Wed Sep 24, 2008 2:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Sequencer problem
Replies: 19
Views: 5627

That's the generated OSH, which does not show partitioning or, indeed, anything about parallelism because the latter is not determined until run time.

I asked for you to dump and post the score.
by ray.wurlod
Wed Sep 24, 2008 2:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Generate Time Stamp Value
Replies: 7
Views: 3262

This is something you will need over and over: the ability to generate the current date/time as a timestamp. I advise that you create a Transform or even a Routine. I call mine NowAsTimestamp. Oconv(Date(),"D-YMD[4,2,2]") : " " : Oconv(Time(),"MTS...
by ray.wurlod
Wed Sep 24, 2008 1:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Sequencer problem
Replies: 19
Views: 5627

Please dump and post the job score.
by ray.wurlod
Tue Sep 23, 2008 11:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: adding user in administrator through datastage server
Replies: 2
Views: 1282

Welcome aboard.

The answer is: no-one can help because it is not possible to do it through DataStage server.
by ray.wurlod
Tue Sep 23, 2008 9:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Comparing two values from the same column
Replies: 1
Views: 1199

Sorted data, stage variables. Search for the rest of the story, how stage variable may be used to "remember" a value from the previous row.
by ray.wurlod
Tue Sep 23, 2008 9:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance Tuning
Replies: 13
Views: 2601

The 20MB per node in the Sort stage is memory, not scratch disk. The process will go to scratch disk if that amount of real memory can not be provided on demand. Assuming nothing else is happening, you need 216 million x 20 bytes (approximately 420 MB) of scratch disk space to handle the worst case ...
by ray.wurlod
Tue Sep 23, 2008 9:35 pm
Forum: General
Topic: How to find the logs pertaining to the current run?
Replies: 3
Views: 1054

Even minimal research on your part would have discovered it.
:roll:

Code: Select all

dsjob -lognewest ProejctName Jobname STARTED
by ray.wurlod
Tue Sep 23, 2008 8:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Could not delete partition 0
Replies: 1
Views: 2062

You had a filesystem related error. Nothing we here can do about that.
by ray.wurlod
Tue Sep 23, 2008 8:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Splitting the coulmn in a record
Replies: 14
Views: 4100

Hi, The job flow is as follows: Input ---> Transformer ---> File---> Table In Transformer, Suppose if a column address needs to be divided into address1 and address2, the derivation for that column(address) is given as Ereplace(FromProgressICSP.addr, ";", Char(13):Char(10), -1). Please help me how ...
by ray.wurlod
Tue Sep 23, 2008 8:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Failing to connect to UniData 6 database from Designer
Replies: 9
Views: 2267

Maybe they want to replicate the Repository in a UniData database?
:?
by ray.wurlod
Tue Sep 23, 2008 5:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with vmdsedit.dll in DS v8.0.1
Replies: 5
Views: 2759

Maybe your super-enhanced caffeine.dll is interfering with proper execution of vmdsedit.dll.
:lol: