Search found 42189 matches

by chulett
Fri Apr 09, 2010 6:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Changing values of Environmental variables at run time
Replies: 7
Views: 2547

Add the $APT variable as a job parameter, then it can then be changed at runtime in that job's environment (and just for that run) just like any other parameter.
by chulett
Fri Apr 09, 2010 6:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing low values in the output file for certain columns.
Replies: 8
Views: 4625

From what little I recall, "low values" would indeed be "hex zeroes" so you may not actually be setting this up correctly and thus ending up with a decimal zero instead. Can you explain exactly how you are doing this? Field data type, derivation, etc etc.
by chulett
Fri Apr 09, 2010 6:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: restart sequence from checkpoint without aborting other job
Replies: 28
Views: 15273

Best example would be in any existing checkpoint enabled job. Check the Job Control tab under Job Properties, the fully generated code will be there including all of the checkpointing logic. Basically, you are leaving "bread crumbs" to show where you've been and what the result of each ste...
by chulett
Fri Apr 09, 2010 6:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to find the Job Type?
Replies: 5
Views: 2808

Oh... he's just a treasure. :wink:
by chulett
Fri Apr 09, 2010 6:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding logic
Replies: 7
Views: 2608

What database do you have at your disposal? Are you allowed to create temp/work tables in it?
by chulett
Thu Apr 08, 2010 9:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Conversion
Replies: 9
Views: 3449

:wink:
by chulett
Thu Apr 08, 2010 7:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Do DS_JOBS, DS_AUDIT and DS_JOBOBJECTS exist in Version 8.X?
Replies: 2
Views: 2558

Yes, they still exist and are 'supplemented' (not replaced) by the XMETA repository.
by chulett
Thu Apr 08, 2010 5:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Repetetive XML tags
Replies: 3
Views: 2129

Can't check right now but there's an option in the XML Output stage to "group" your data from what I recall. How is that set?
by chulett
Thu Apr 08, 2010 5:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple instance job finished, but don't do anything
Replies: 11
Views: 3372

have somebody a hint for me, how I can analyse the problem, because I have no further idea on than issue. I'm curious how Ray's "hint" was any different from mine. Other than coming from Him, of course. :? Within the job design the invocation id is not used. I find that hard to believe, g...
by chulett
Wed Apr 07, 2010 2:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error during writing to a FTP stage
Replies: 4
Views: 1722

Since we don't know just exactly how "same" your "same issue" is, it is always best to start a new post with your particulars and actual error(s).
by chulett
Wed Apr 07, 2010 11:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Conversion
Replies: 9
Views: 3449

Pretty close. :wink:

The 'output' conversion mask is off and needs to be more like what you have on the input side:

Code: Select all

OConv(Iconv(DSLink4.ModifiedDate[1,10],"D/DMY[2,2,4]"),"D-YMD[4,2,2]")
Technically, the IConv mask can be simplified but that should work more better for you.
by chulett
Wed Apr 07, 2010 11:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: restart sequence from checkpoint without aborting other job
Replies: 28
Views: 15273

Please understand - you cannot make the built-in automatic check-pointing work the way you 'need' it to work, so you should put that from your mind. For the behaviour you say you want, you'll need to (in essence) build your own check-pointing system, one which may (or more likely may not) require th...
by chulett
Wed Apr 07, 2010 10:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Conversion
Replies: 9
Views: 3449

Split the date from the time, use the IConv/OConv functions to convert each component and then cat them back together. If you really need the milliseconds then just stick the ".000" on the end. Both 'conversion' functions are well documented in the Help, give that a shot then let us know w...
by chulett
Wed Apr 07, 2010 7:33 am
Forum: General
Topic: Upgrading DataStage Server Edition to a Parallel Extender
Replies: 5
Views: 1685

That was the 'technically' part. :wink: