DSXchange

What datatype you have defined in datastage metadata and what is database?

Yes i am using the basic tansformer stage.My job design is like below:- Read SeqFile----> SP -----> Filter ----error code=-1006 ----Basic Trans--->Aborter after 1 rows ------ErrorCode=0 -------Cpy stage(Success) ------Error<0 and <>-1006 -------> Basic Transformer---->(Abort After 1 Rows) Below are ...

Hi,
Are you sure you are doing update on Primary key column,to test just run the db2 connector stage in sequential mode.

Run the same script on unix prompt and check what output it gives.

Hi Chullet,

I am passing unique name in Invocation ID like
e.g.:-
DFTPM
DFTAM
DWHOPL
DWHAPL
etc.
It runs file but sometimes it fails with above error message.

Is your file coming with null value?
What is the datatype you have given for Date,read it as varchar and transform to date in Transformer.

Hi,
I am not doing any validation in Invocation ID.

Hi,
Yes my all instences are passed as a different variable and main job is not run without any instance.

Hi, I have a multi instence job and it runs for 12 instances but sometimes i get below error and job aborts. Unable to run job - -2 I can not figure out how this is happening because same instance ran before successfully and when i reset that particular failed instence and rerun the job it fails aga...

Yes but some of them are left unmarked and hence identified as issue.It resolved now....

Target Oracle column is defined as NUMBER(16) and i think this value will fit into this datatype.
What conversion function i need to apply in transformer to convert varchar into Number(16)

Hi, My source and target is Oracle and one column STYLECOLOR is in source is VARCHAR and same column in Target is Integer and data will be interger only. When source data is long integer value like "99991013751235" then in target its converted as "2147483647". I am not applying a...

Hi,
I asked my client to change the datatype of my input parameter of Stored Proc from BLOB to CLOB and its working fine now.

Below is my PL/SQL block DECLARE RetVal NUMBER; P_PAYLOADUUID VARCHAR2(40); P_PAYLOAD AITBROKER.STR_PAYLOADS.PAYLOAD%type; P_TRANSTYPE VARCHAR2(20); P_STATUS VARCHAR2(15); P_TIMESTAMP TIMESTAMP; P_ADAPTERTYPE VARCHAR2(20); P_PAYLOADSIZE NUMBER; P_ERRORMSG VARCHAR2(32767); RetVal := TRANSMISSION_ETL....

Hi Chullet, First i have done it in PL/SQL code and i have called in Oracle connector stage.But their requirement is something different.There are two output variables Error_Code and Error_value and they want me to handle in datastage like If (Error_Code<0 and Error_Code=-1006) dup check is failed e...