DSXchange

Hi,

I am having a stage variable into which i am populating the Dsstart date. Now this date i have to basically write to a DB2 table having a field called Date. I am using a DB2 API stage and would like to understand what user defined query shall i write.

Welcome aboard. :D

The easiest solution is to let the DB2 stage generate the SQL. You just provide the connectivity/authorization information, the table name and the column name(s), deliver the values into those columns within your job design, and whether you want to insert, update or some combination thereof.

Keep in mind that the DB2 stage will want dates in internal format from what I recall.

If that's the case, apply an Iconv() function in the stage variable derivation.