DSXchange

Hi All Thanks In advance... the following is my scenario i am calling 1st perl scrit in sequencer chich takes a sequential file as the input.This script will archvie this file to one location.in the next execute command activity i am calling another perl script which ftp s this file to another serve...

Hi , The following is the scenario I have one dataset which have two types or records one is A type and secod is B type. For A type records delete the corresponding records from the X. For B type records insert if it is a new record and update if it is an existing record in table X. Can anyone sugge...

HI, In my job i am concatenating a column(C1,VARCHAR) of length 200 with a string of length 20. If the input for the column C1 is small it is concatenated with the string.If the C1 s value is lengthy then the concatenation is not happening in the output. Output column is of varchar and length is not...

What does the delta logic means...

In which way we have to start doing analysis of the jobs to find out the delta logic of the jobs?

Is it a kind of Exctraction logic?

I am surprised by your assertion that this works in DataStage. It returns different number of columns for different cases, which can not match your metadata. You must have been lucky and only had ca ... Based on the column AMZN_PREP_DESC_T value , i am assigning different values to the same column....

Hi, I have some job parameters in my job which is having length of 60 . I am using these parameters in API stage query. Query contains case statement . These job parameters are used as case values. When i am running my job from datastage it is running fine. When i am running the same using scripts i...

Hi ,

I am inserting records into three tables in db2. I a am using API stages. How can i capture the rejected records(error records) by the database

Thanks in Advance
M

Hi , I am using stored procedure stage to invoke one stored procedure in db2.It does not have any i/o parameters. The procedure is creating one cursor .I need to get that cursor values as output values. When i am trying to execute my job it is giving the following error. Stored_Procedure_0,0: Error:...