DSXchange

If your DB2 Connector stage is a target, you should be able to have a reject link pointing to a sequential file and have the reject records written to the file. If you only want the record written to the file with out the error code or error text, you would not check either of the check boxes. If it...

Try looking on your client. DSCMDEXPORT is a client-side application.

To answer your initial question, the screen-shot you provided is the DB2 UDB API Connector, not the DB2 Connector. The DB2 Connector is available as of 8.1, but I believe you have to install Fix Pack 1 first. I would recommend using the DB2 Connector since it has better error handling. Both the Conn...

I just checked our CASS installation and the _MWT_UP.CFG file exists in the CASS_Database_files directory. I would guess your migration didn't work correctly. You should probably download the latest Address Certification files for your version of DataStage. Also, as for your comment about not having...

As Ray said, it doesn't really matter where in the dsenv file you set the variable. I don't know the different time zone settings very well, but I would think for US Eastern, you would use EST5EDT instead of EST8EDT.

You have appended your problem onto a posting created by Sreedhar. Did you try his solution in the post dated Mar 22, 2010 9:26 am? Sreedhar was our admin when he created this post and the solution he found fixed our issue which sounds just like the problem you are discribing. Of course, since you a...

We are attempting to justify a full-time DataStage Admin position in our company. We currently have 6 full time developers, plus several part time developers. Admin duties are shared among the developers. We support hundreds of DS jobs/sequences that run daily, weekly, and monthly (even a few that r...

Try DecimalToDecimal(InputColumn,"round_inf"). Make sure to set your output column to decimal with a scale of zero.

The transformer is the easy way out but the most costly in terms of performance. According to IBM's training materials for Advanced DataStage Training (DX445), page 322: "Transformer constraints are FASTER than the Filter or Switch stages. Filter and Switch expressions are interpreted at runti...

Hi All,

I never got a chance to work with writing Routines and shell scripts.
Can you pls suggest me what are the resouces that will help me to begin learning Shell script?

Thank you
Mannu

Do you need the field to be Char? Why not leave it as a Timestamp (length 26) and set the Extended property to "Microseconds"?

Your SCD Stage window may be opening up off-screen. Does DataStage appear to lock up? If so, the next time the properties window doesn't open, try pressing Alt-Tab to see the list of open applications. If you see an unknown window, select it and then move it back onto your screen. Since you can't us...

Thank you its very clear.

Yes we are using sequential file,I'll search your blog on the net and look at the xml content you posted but I have one question why do we need to use external source instead of sequential file.I could not understand the problem.Appreciate for your response and help.

I have a job where I am extracting xml file/document which contains 58 from an XML file/document,importing xml schema from xml document and writing to a sequential file.I am importing the metadata using the xml file instead of xsd.I validated the xml file using w3schools xml validator and it shows m...