Search found 42189 matches

by chulett
Thu Aug 23, 2007 7:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to open descriptor file to create - Fatal Error
Replies: 13
Views: 12313

How, exactly, did you 'copy' the jobs? How did you make it NRO?
by chulett
Thu Aug 23, 2007 7:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help Text for Environment Variables
Replies: 6
Views: 1323

Post it in the Enhancement Request forum. Which does, as far as I know, really get 'taken up' with IBM.
by chulett
Thu Aug 23, 2007 7:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal overflow handling when loading flat file
Replies: 1
Views: 1232

A) That's not huge. B) Post your actual error(s) and your handling details.
by chulett
Thu Aug 23, 2007 6:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Merging multiple XML files in to one Final XML
Replies: 3
Views: 1220

Sheesh... first off, learn how to quote someone properly. And nothing works except plain text when you enable the 'Disable BBCode in this post' option. Same techniques should work, just think a little outside of the box. If there's truly no relation between them, consider creating one, even an artif...
by chulett
Thu Aug 23, 2007 6:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Output stage Issue
Replies: 5
Views: 1457

Re: XML Output stage Issue

But when the Xpath is imported it will import only Two fields statcode & stavalue,but for these columns i need to push Eight Fields of data. That's because there are only two elements. Doesn't matter how many 'fields of data' you have. I would think you just need to use the two and then mark on...
by chulett
Thu Aug 23, 2007 6:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help Text for Environment Variables
Replies: 6
Views: 1323

I have no idea why this would be disallowed, but the answer is 'no'. :(
by chulett
Wed Aug 22, 2007 11:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Difference between hash & hashed file
Replies: 3
Views: 1012

No such thing as a 'hash file', unless - as Ray is likely to say - you are planning on shaping a block of hash. The proper terminology is 'hashed file'.
by chulett
Wed Aug 22, 2007 11:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conditional execution of next job in sequence
Replies: 22
Views: 5767

Why a UserVariables stage? Are you planning on driving a Loop? Use a Routine Activity stage and conditional triggers for this task.
by chulett
Wed Aug 22, 2007 11:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Merging multiple XML files in to one Final XML
Replies: 3
Views: 1220

Download the XML Best Practices document from Kim Duke's website. It will lay that all out for you, how to combine intermediate chunks of XML into your final schema.
by chulett
Wed Aug 22, 2007 11:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conditional execution of next job in sequence
Replies: 22
Views: 5767

Hold on... you're trying to attach to a job, interrogate it for link counts (etc,etc) all in a UserVariables Activity stage expression? You'll need to write a routine to do all this and pass your found value back out, then leverage the routine's $ReturnValue there. Edited to add: Actually, what valu...
by chulett
Wed Aug 22, 2007 10:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conditional execution of next job in sequence
Replies: 22
Views: 5767

You need to include the proper header file:

Code: Select all

$INCLUDE DSINCLUDE JOBCONTROL.H


Or more properly:

Code: Select all

$IFNDEF JOBCONTROL.H
$INCLUDE DSINCLUDE JOBCONTROL.H
$ENDIF
by chulett
Wed Aug 22, 2007 10:22 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: RTI introduction
Replies: 8
Views: 5268

Of course, as do mine. I realized after I posted that 'my' jobs only used the XML Input/Output stages for testing and that I can replace them with RTI stages because we use XML Transformers inside the job when the XML needs to be manipulated. The RTI stages happily pass along any kind of squirt of i...
by chulett
Wed Aug 22, 2007 9:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DaysSinceFromDate - Only Business days
Replies: 2
Views: 1598

Probably the best answer. You might enjoy this post, thought of your issue when I read it. :wink:
by chulett
Wed Aug 22, 2007 9:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Load Problem
Replies: 15
Views: 4462

Then you need to work with them to ascertain what is different between your 'Oracle system' and theirs. First thing I'd wonder about would be the specific release of the Oracle client both are using.
by chulett
Wed Aug 22, 2007 7:35 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: RTI introduction
Replies: 8
Views: 5268

As Ernie notes, as the last step Ray mentions I typically replace the XML stages with RTI stages.