DSXchange

Hi, I want to merge 4 columns from 1 sequential file and 1 column from second file. Eg: file1 ------- id, name, imp 1, A, 10 2,B, 20 file2 ------ Date 20051231( only 1 record) output ------- id, name, imp, Date 1, A, 10,20051231 2,B, 20,20051231 1 I tried link collector but both files should have t...

Hi

i have installed datastage on my PC.when i tried to conenct to the administrator ,it is giving error like unable to connect to host,invalid host name....
i have supplied the correct hostname ,username and password..
what could be the problem.....
Thanks in advance for any suggestions....

thank you very much...

it is working fine.

Hi thanks for ur quick response...
but still i have one doubt that ..in that scenario if u have duplicate records it will work..as u explained in the example what happens to first record itself..the condition will not satisfy..right....for the second record it is ok...

please clarify me ....

thanks

Hello there, I think you cannot use the Hash file stage if the source has many records. We accomplished the task by using Stage variables. The only requirement for our approach is that the data has to be sorted before it arrives to the Transformer stage For example if the source file has 4 columns ...

Hi All,
can u please help how to write Userdefined Routines in DataStage PX.

thans in advance

Hi All, This is Anil, i am converting the source field which is in VARCHAR format to DATE data type.During this conversion ,i want to capture the ERROR Messages that occur during the conversion. how can i capture this messages. did any one face this problem.....help me Thanks in Advance. Hi i am st...

Hi All,

This is Anil,
i am converting the source field which is in VARCHAR format to DATE data type.During this conversion ,i want to capture the ERROR Messages that occur during the conversion.
how can i capture this messages.
did any one face this problem.....help me

Thanks in Advance.