DSXchange

Could someone help me on this issue...

The datatype of two columns are char(1). If use @ or any special character .Then i need to change into space in final job which will load into target table.

Hi All, I need your help in writing NULL values and spaces to db2 table. Iam simply extracing data from db2 table with the below structure and writing into flat file without any transformations and i set property as Null filed value ='' in the sequential file stage properties. But my table contians ...

Thanks for your reply.

Can we implement this logic in transformer?

Hi All, I need your help in implementing the below requirement in datastage Iam having 3 columns in a sequential file with comma delimeter.And i need to write into one sequentail file.. And my testdata is :: 1A,aaa,1 2A,bbb,2 3A,cccc,3 4A,ddd,1 And i need to produce the ouput based on third column v...

Could you please someone provide reply for my requirement

Hi All, Iam having one requirement to load data into Materlized Query table(DB2 ) same as Materlized view( Oracle. ) My source is Dataset.And i'm using Datastage 7.5 version. Please let me know whether it is possible to load the data into Materlized query table through datastage parallel job. Thanks...