DSXchange

We also faced same issue, but we are also not able to remove those warnings.

Please use below code to resolve your query :

Specification=Col_name= Handle_Null (Col_name,Default value )

Please check if you are using same table for fetching the records and same table to update or insert the records in same job.This situation also can create deadlock.

Thanks a lot for pointing me to the site.
Thanks
Dash

Hi All, My Datatstage job consist of a DB2 stage then a Transformer then again a DB2 stage.In transformer stage I am using a Isvalid function to convert the char filed to decimal field.Can anyone suggest me if the same thing can be written in DB2 query? For debugging my answer i need this. Any sugge...

Hi, Can any one let me know... While using DB2 stage as output, I want to use the option "open command".There I need to use a db2 utlity command import from....... This command is not a db2 query.This is a utility command.So does any body know how to use this utility command? Thanks In Adv...

Hi All,

Actullay I am fetching data from table XYZ and updating the same table XYZ after some transformation. Hence Job is getting Hanged.
please help me.

The solution can be create one more job but we can't.
Now this stage it is very hectic to create new job.

Thanks in Adavance.

I am calculating sum of column Col1 having datatype decimal(26,3) in db2 stage and After calulating SUM the datatype for output column is Double (31,3). Later I want to populate this double(31,3) value in Output column Col1 having data type Decimal(26,3).I want to populate data in db2 table. I did t...

I need a type conversion.So for one field I donot want to use ant stage.Can i use any logic like if the source vaue is of some particular range(as per decimal range) then how can I map it to target which is Integer(10).? My question is can i take some upper bound and lower bound facility and can i m...

Hi,
Any one can plz help me to do a filed conversion.

My source is EEDBPE (Decimal(15)).I want it to map to the filed TRAN_AWRD_CNT (Integer(10)).


Can any one give me any sujjestion wether I need to validate the source filed to IsValid('INT32',EEDBPE) or will I do direct mapping?

Thanks a lot for all you answers.

Thanks
Dash

Hi
Can any one tell me
what is the difference between DB2/UDB API Stage and DB2/UDB Enterprise?
In my project DB2/UDB API stage is used to populate i-series.Why not DB2/UDB Enterprise?

Please help me to clear my doubt.

Thanks
Dash

Hi In my job I am having DB2 and Sequential file as my source file.When I am removing 4 columns from both the source(as using funnel as next stage) i am getting some error in my transformer.The error is something like ........ )} It runs 1 process on 1 node. ##W TCOS 000049 23:24:40(000) <main_progr...

Thanks a lot for guiding me..

I am new to PX