Search found 42189 matches

by chulett
Fri Feb 09, 2007 8:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: oracle OCI loader
Replies: 1
Views: 810

Yes, it does. The difference is that automatic mode basically 'back doors' the operation and talks directly to an API - I don't remember the name but it's in the help for the stage. It is speed limited by how fast you can pump data to it. I've never measured the speed difference, but it doesn't surp...
by chulett
Fri Feb 09, 2007 7:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: difference between 7.5 and 7.5.2
Replies: 8
Views: 1500

Lots of fixes... enhancements too, from what I recall. As noted, it will be in the README.

(I'm trying really hard not to just say ".2" but it's obviously not quite working)
by chulett
Fri Feb 09, 2007 7:54 am
Forum: General
Topic: Date after File Name
Replies: 4
Views: 1551

That's certainly the easiest way, if you can pass the date in. You can also (script or routine) write to a fixed name and rename it 'after job'.
by chulett
Fri Feb 09, 2007 7:52 am
Forum: General
Topic: Read Log of another jog
Replies: 3
Views: 1508

In other words, you don't need to read the other job's log to get that information. There are functions to allow you to check the job directly if all you want is the information from its most recent run. There are also functions to pull information from logs, DSGuru noted one such. There are also al...
by chulett
Thu Feb 08, 2007 8:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Filter records more then decimal(12,2)
Replies: 10
Views: 2284

Give you some candy :?:
by chulett
Thu Feb 08, 2007 5:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob
Replies: 17
Views: 5311

Must be more than that, yes? :wink:

Edit your post to fix it rather than posting it all over again.
by chulett
Thu Feb 08, 2007 5:30 pm
Forum: General
Topic: DataStage and the DST change
Replies: 11
Views: 9575

vmcburney wrote:So the question is, does the DataStage server have a java runtime environment on it?

Most definitely. Used by the XML stages at the very least.
by chulett
Thu Feb 08, 2007 5:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob
Replies: 17
Views: 5311

Post your script.
by chulett
Thu Feb 08, 2007 4:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to check the value if it is not a CHAR
Replies: 5
Views: 2149

Depends on your definition of CHAR. Have you checked the Alpha function?
by chulett
Thu Feb 08, 2007 4:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How do you remove empty tags from a XML file
Replies: 6
Views: 2127

Are you reading or writing this xml? If writing, passing a null value should result in the tags not being included, while an empty string will result in empty tags. It can also depend on which (if any) of the following Transformation Settings you have enabled: Replace NULLs with empty values Replace...
by chulett
Thu Feb 08, 2007 2:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ETL PGM Unlock
Replies: 8
Views: 3223

Doesn't work how?
by chulett
Thu Feb 08, 2007 1:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine job did not finish OK
Replies: 15
Views: 17308

Uncheck it. That option says you want something logged in that case. The assumption before this has been that you have the 'Automatically handle activities that fail' option enabled, the 'two trigger' approach was specifically for that. If you enable the option you noted, it will always log the war...
by chulett
Thu Feb 08, 2007 10:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine job did not finish OK
Replies: 15
Views: 17308

Post your triggers not the Sequence code. Also tell us exactly which 'Compilation options' you have checked in the job properties and your exact version of DataStage, please.
by chulett
Thu Feb 08, 2007 10:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine job did not finish OK
Replies: 15
Views: 17308

Yes, I've done this several times and know it works if done properly. So, what exactly happened when you used both a 'Failure' and 'Otherwise' trigger from the routine to a Sequencer set to 'Any'?