DSXchange

As per my understanding of your requirement,,, If you have seperate key columns in both source and reference files, you can do lookup based on that key columns and then in a transformer you can check for the column (which seperates header and details) . If that column equals A, then do calculation f...

Try this, select (given_date +1 month -day(given_date) day) lastday from tablename ;

In the syntax tab of Stage properties of SP stage, set the procedure type to "Transform". Then in the Parameters tab set the input and output parameters as u need...In the Input properties tab, click on "Forward row data" and "Execute Procedure for each row"

[quote="userasif"]After some changing now I am getting this message: At row 1, link "OutLink" Inserted value too large for column, row rejected.[/quote] Try by giving tripe the size of the original column size for Arabic columns. Because Arabic characters are not of same size as ...

jst appyling trimming function and filtering

Hi,

I need to use a transformer stage after a sequantial file stage which is the source. I have no idea on which partition to be used in the transformer stage that is after the sequential stage. Can anyone help me on this...
Thanks in advance....

Regards,
Grace J.

Hi,

I have cretaed a stored procedure in db2, which will update the records in a db2 table. I don't have an idea of how to call that stored procedure from datastage. If anyone have an idea on this,,,, Pls help me.....

Thanks in advance...