DSXchange

Hi All, I have a Hash File Stage which has few duplicate key records going in and as HashFile Stage works, I am getting last input duplicate key record as output. Is there a way to get the first record among the duplicates as the output. I am using a sort stage and and a surrogate key to get the fir...

Hi All,
I would like to know whether we can retrieve the User ID( ID of the User who invoked the run) from Transformer Stage...similar to using DS Macro. If there is a way, Pls revert.

Thanks In Advance,
Tom.

Thanks Poorna. It's compiled now and working fine now.

Hi All, I am facing a problem with Link Collector. There are two inputs to this link collector. While compiling it is giving the error "Link Collector Stage Does not Support in-process active-to-active inputs or outputs". Will any one give some input to solve the problem. Thanks in Advance...

Hi All,
In DataStage, is there any way to remove all the characters from a String except digits 0 to 9.

Thanks In Advance,
Tom.

..it worked...but not before some anxious movements..

Thanks,
Tom

Hi, I am facing a problem with exporting the Job Designs and Job Executables in my project. I am unable export the job category wise. For Routines and shared containers etc.. it's working fine. If I try to export the job category wise, it is giving the following error. "Error calling subroutine...

Hi Phil,
The problem is resolved. It was because of wrong partner profile given in SAP Client Connection settings. I had selected the default one but actually it was someting different.

Thanks & Regards,
Tom

Hi Phil,
I have set all except Primary Key and Foreign Key Fields to Nullable.

Regards,
Tom

Hi Phil,
Thanks for your reply.

I am not getting any similar messages as you have given but there are no warnings form the job. Yes there is one mandatory segment and it's populated.

Thanks,

Tom.

Hi All, I am using IDOC Load for R3 Stage to create IDOC in SAP. Data is passed to IDOC Load Stage from a hashfile and have multiple links going into it. The Job run completes without any warnings and in Job Monitor, the number of input and output rows are same for links going to IDOC Stage..but no ...

Hi Ray & Roy,
Thanks for you reply. I tried the methods but did not work. Finally got one idea, just deleted the directory at Unix OS level and recreated it. It woked.!!

Thanks,
Tom.

Hi, I am trying to read files from directory at OS level using folder stage. The transformation Job immediatly after the folder stage throws the following errors "DSD.UVOpen Unable to open folder /prj/board/chk/cust/reception" "DataStage Job 1656 Phantom 16368 Program "DSD.DIROpe...

Thanks Chulett. I have installed the SP2 Patch and it's working fine now.

Thanks.

Hi Srini,
Thanks for your reply. I granted the right permission to Datastage directory in my client to the user. But still I am unable to see the properties.

Regards,
Tom