DSXchange

Hi Guys,

Would some one help me in figuring out whcih version controlling is better than version control which comes with datastage, compare to such as PVCS or VSS. to vesrionize jobs for Datastage.

Thanks
srimitta

Thankyou Ray and to everyone....

Hi Ray,

Thanks for ur reply. Iam unable to follow you, Would you please give me clear picture, it will be a great help to me.

Thankyou
srimitta

Hi Klaus,
Thanks for reply

We have ETL jobs developed for DB2 on MF's, Now we are implementing Datastage MF version.
Here how we can import all those to Datastage and run.

srimitta

Hi, I have couple of issues, would you guys please help me. 1. We have ETL jobs develped in COBOL, How to import into DataStage. (Apart form importing CFF , is there any other way without sacrificing originality of the COBOL code). 2. DataStage390 generates Cobol code,Jcl file and Run file at job co...

Hi gurus,

Would some one please help me how you define LOOKUP stage in DataStage 390.

Thankyou
srimitta

Thankyou

Hi Guru's
can we call container stage developed in datastage server jobs into mainframe jobs.

Thanks in advance
Srimitta

Thanks for your reply. really it helped me.

Hi Guru's,
some one help me with diffrence between FUNTIONS AND MACROS
Thankyou
ms

Hi, My source is ODBC from oracle table with column name HIREDATE,format is Timestamp (1980-12-17 00:00:00) . Here iam trying to convert date fromat to (17/12/1980) , for this conversion i used CODE: Oconv(Iconv(DSLink3.HIREDATE[1,10],"D-YMD[4,2,2]"),"D/DMY[2,2,2]") In CONSTRAINT...

HI,
I am getting same error Attempting to Cleanup after ABORT raised in stage oraseqdate..Transformer_1

Hi thanks for reply,
I tried your CODE but i am getting same error.
Input date formate is TIMESTAMP(1980-12-17 00:00:00) , I want to convert to 17/12/1980.
Thankyou
ms

Hi, i tried the below code in the constrain to change the date format DSLink3.HIREDATE=Oconv(Iconv(DSLink3.HIREDATE,"D-YMD[4,2,2]"),"D/DMY[2,2,2]") but i am getting the following error: Attempting to Cleanup after ABORT raised in stage oraseqdate..Transformer_1 what exactly i hav...

I am trying to do conversion in transformation stage