DSXchange

As a part of ETL migration we thought of converting server job date format to be generated by parallel job.But we couldnt acomplish by parallel job hence we used the same.

Hi All,

In server jobs if i give @DATE as derivation its converting to Datastage internal format.

As below:

2015-02-13-->17211

How to acheive the same in parallel jobs.

Thanks
Ramakrishna

Windows update was not done.Other softwares were installed like PDF converter . Antivirus used is mcaffe both datastage and antivirus or on same OS(operating system).Shall i remove antivirus and try ? . I dont have any system restore points to restore back.Please share your thoughts. Thanks Ramakris...

Getting the same error message even when trying to login through the administrator cleint.

But for couple of months i havent faced any issue and i could able to login to datastage and design the jobs and ran it.Now it is giving the above error message.

I have datastage installed in my windows 7 pc. Getting below error message when i want to login into datastage designer/director below is the error message . "Subroutine failed to complete successfully (30107)" I have followed the steps provide in the IBM supprot link http://www-01.ibm.com...

Can we extract the delimited text file using sequential file in parallel mode?
I know we can extract fixed width files.If we couldnt extract the delimited file paralley...what constraints doesnt alow to extract parallely.

Thanks
Rk

i have one question... in Connector Stage for bulk load operation we have properties as Discard dataset, Error dataset, Map dataset, work1 dataset and work2 dataset . I don't understand the purpose of those so i have left blank. Do they create the datasets in the mainframe and then load to the datab...

I have given the ftp ip address of the DB2 database.Do we need to give the ip address of the mainframe or Db2 database.Could you please elaborate on the above comments so that i can well describe about this to admin.
Thanks for your contribution.

Below are options we enabled: We have enabled write mode :Bulk Load Enabled Bulk load to DB2 on z/OS:YES Load Method:MVS dataste(s) transfer type:ftp transfer to:given the ip address of the mainframe db2 user id password below options we havent given anything: Datafileattribute Inputdatafiles filedi...

Please find the below error message we are receiving: Transfer to dataset JDBCBDW.IN00000 failed with error: 550-SVC99 RETURN CODE=4 S99INFO=0 S99ERROR=1224 HEX=04C8 S99ERSN code X'00000FD6'. 550 Unable to create data set JDBCBDW.IN00000 for STOR command. cat: 0652-054 Cannot write to output. There ...

The DB2 is on Z/OS system we tried with connector stage with bulk load and we gave the ftp ip address ,user id and password.But the job got aborted.

Hi ALL,

How to achieve the DB2 Bulk load using DB2 Connector stage? There are many options available so what exactly we can select from those? Please share your thoughts.

With the help of stage variables and looping and data sorted we acomplished.

we have created unix shellscipt and worked out. Thanks to all