DSXchange

The problem that I am facing is, when I view data in datastage for the sequential file , the output is weird (it has special characters like ?). This is specific to your NLS_LANG setting on your PC not DataStage. The DataStage setting will only be used when the job runs. I'm not familiar with an NL...

What kind of sizes would you be dealing with? There are definite size limits when using the traditional 'two fields, all content at once' methodolgy with the Folder stage. Cutting that back to just one field to pass the filename and letting the XML Input file read the file directly pretty much remov...

How can i access multiple remote oracle database instances(all of the same version 10g) using Oracle Enterprise stage plug in ? To my knowledge , only one ORACLE_SID is accesible in Oracle Enterprise stage. The 'SID' is NOT a connection option in the Oracle Enterprise stage also. One SID per stage,...

This has nothing to do with DataStage being a 32bit app but is strictly a limitation imposed by the O/S.

There should be another message with why it couldn't. Also curious if you get this right away or after a large number of records have been written?

Talk to your SAs or whomever supports UNIX there. You'll need to up the 'memory' options and probably point to a larger 'tmp' area, from what I recall.

Turn off the option that includes it - the Comment option under Document Settings from what I remember.

No, there is no macro for that - you would need to query the repository. I've done that inline in a job using a UV stage lookup, it's not that difficult to setup.

No, not clear yet. Capture in what sense? And then do what with this captured information? If you are running your jobs using the dsjob command, the -jobstatus option will cause it to return the normal DataStage completion codes: 1 = Finished Ok 2 = Finished (see log) 3 = Aborted etc. Would that help?

Or... perhaps... just check the man page.

Yes, there is a Sort stage in Server but external sorts are typically much faster. As noted, even the plain old command line sort beats the pants off of it. Even better if you have a 3rd party high-speed sort utility.

Still curious how one would do this without leveraging 'outside' components...

How new? What do you mean by 'Describe my project'? Are you currently working somewhere with DataStage? Who knows what someone will ask during an interview - I've seen times where a resume was looked at and a body brought in, no questions asked. Didn't last long, either one of 'em. I think Vincent ...

Your job must abort to roll back transactions - is that happening?

Special characters meaning this column name was the problem? 'I4SEQ#'