DSXchange

Make sure you've spelled it exactly right - case matters. And it needs to be an active stage - like the Transformer that feeds the output stage, not the output stage itself.

:D , The last time i got this error, all freestanding files in my $DATASTAGE/projects/ProjectName directory had been deleted, apparently by a stray semicolon in the filepath of a sequential file being written to the project directory :D . An ECASE has been raised to IBM. LOL Cool, an Ecase to prote...

Exactly the conclusion I was hoping this would come to.

There really isn't a concept of a 'delete' in a Sequential file, DataStage or otherwise. What you need to do is write the file out without including the record(s) you want to delete. In other words, skip the first record in your output logic.

A couple of things to note: Copy stages and 'Runtime Column Propogation' are PX concepts and not applicable here. Build a little test job that all it does is create deliberate errors in a play table and see if you can actually capture these values. Simply building a Reject link will capture the row ...

You can't. You'll either need to write a teeny little test job that calls it or get sneaky and test a version of it in the Manager as a different type. Create a test Transform Function and dump this code in it. Change Arg1 to be named InputArg and add the teeny bit of code needed so it can run stand...

Have done quite that many in one job. How large these XML files anywho? First suggestion would be break this up into seven separate jobs rather than read each file seven times in the same job. Should help with the whole process memory exhausted issue...

suneeth wrote:My requirement is to handle exception and rejection dynamically.

Perhaps you could give a little explanation as to what this means to you.

Your other option, provided you are running a 7.5.x version of DataStage, is to leverage the new looping stages: Start Loop and End Loop. Throw in the User Variables stage to capture the filenames from the file and you can create a loop in a Sequence job that runs your job(s) over and over with diff...

Dump the 'to' between the filenames.

Or bring it up to the 70s... Rowen and Martin.

ps. Direct link to a .wma file recording of Who's on First? for your listening pleasure.

ray.wurlod wrote:No. There is a stage type called Generic. RTFM?

Wondered about that right after I posted, but didn't feel like R'ing the FM so decided to expose my ignorance for all to see.

Yah, you guys make a hell of a team. The Lewis and Martin of DSXchange.

Or just get the 'SP2 Patch' for DataStage from IBM.

How is this related in any way to DataStage?