A very good article describing the usage and syntax for various functions for datastage. Please check theis link : DATASTAGE FUNCTIONS

This error you will get when the user who is running the DSJob is not having the SELECT permissions to the DB Tables. For Clearing this Just Refer the Article Here : http://www.ibm.com/developerworks/forums/message.jspa?messageID=14157876

When you need to send the output from a single input link to many output links then don’t do this in a transformer itself. Instead do it using file copy stage. This really improves the performance and preserves the datatypes.

For removing the Runtime column propagation in all the stages defined in the current job, Goto Job Properties – >  General Tab -> Un check “Enable Runtime Column Propagation for new link” It will ask whether you want to remove the RCP for the existing components also, Say ‘Yes’ now in all the existing links […]

When you get any warning like below, APT_CombinedOperatorController(1),0: Field ‘XXXXX’ from input dataset ‘0’ is NULL. Record dropped. Then don’t ignore this.  Because this will case the job to ignore some records, Means those records will not be processed by any of the following records and you you will not get these records in the […]

In datastage while using the column import stage we may get the following error, main_program: Syntax error: Error in “export”  operator: Error in operator arg: In field “Opt”: Expected “;”, got: “.”, line 53Error in “field_import”  operator: Error in operator arg: In field “Opt”: Expected “;”, got: “.”, line 92 The main reason for this […]

I was trying to do some string manipulation things in a Job in Datastage. Oops i forgot to mention the tool, its Datastage 7.5.1. As we knows it supports basic functions and few stages where we can do data manipulation and other stuffs. Still we cannot say that we can achieve all manipulations using those […]