DSXchange

Hai, I'm trying to convert VARCHAR(40) data from an Oracle DB source on windows to date data format for an oracle output table. My Source Column is (Start Date -(mm/dd/yyyy) ) Datatype : Varchar Target Datatype is (Agg_Start Date) -(dd-mon-yyyy)) Datatype: Date. I have tried this format : OConv(ICon...

Hi,

One of our job is throwing waring with message
"OCI has fetched truncated data".

Any idea why this error is coming.

Cheers

Hi,

I am very new to this tool.

I want to delete some records of a table using DataStage.

Please suggest me some effective way to do it.

Cheers

Any idea how can I clear log of all the jobs in a project?

kcbland wrote:If the job logs also were corrupted, mass compiling often fixes that problem as well. ...

Hey Ken,

How can we do mass compiling ...?

Hi , We developed some jobs couple of days back. Now if I open all the jobs some are giving error : "Cannot open executable job file RT_CONFIG2646." I tried to develop new jobs there I am getting error : "Write error on DS_Temp record 'P\ErrorTest.Transformer_CA.DSLink162',status()-2(...

Hi ,

While compiling some of the jobs we are getting following error :

Error caling subroutine :DSR_Job (Action=5);check DataStage is set up correctly in project mgt_dev
(Subroutine failed to complete successfully(30107))

Any idea what is causing this error ?

Cheers

The group by solution is not working..... My problem is I have catch duplicates depending upon the values of two column and if 2 rows are matching then I have two catch both rows not one. Like a,b a,b x,y y,x c,d c,d in this case I have to catch a,b a,b c,d c,d Please help me in solving this. Thanks

Hi All, I am new to DataStage and struck on one problem.I am unable to find any solution using help provided by datastage. I am using an oca stage as source.I have to catch the duplicate records and put those duplicate records in sequential file. The records are in this format: Col1 Col2 Col3 x y z ...