DSXchange

Instead of using routine for the above requirement, can we use a shell script, i thought of doing but dsjob -report <Projectname> <JobName> BASIC > log.txt ************************************************** STATUS REPORT FOR JOB: <JobName> Generated: 2010-06-29 10:06:45 Job start time=2010-06-29 08:...

Thanks duke, I am able to go through your site, but i am not able to find out the correct routine which is required for my requirement. I am new to routines and may be this is one reason i am not able to find it out. Thinking of writing a routine, but i am stuck in how to connect to oracle database ...

We are thinking of implementing a routine for each sequence, once it is failed the table will be updated and if it is successful, at the end a routine to update the status ok.

@kunal,
We could not find any routine corresponding to this in the duke's website.

Can you please suggest us on this.

Hi All, I have a requirement where in i need to update a table, if the job is failed or success a table need to be updated with the below fields to be populated. JOB_SEQ_START_DT JOB_SEQ_END_DT DURATION STATUS (OK/KO) Split job --> Tranfm job --> Load job. Can you please suggest me on how to proceed...

Ray,
Can we install any version of Datastage on external hard disk and access it through our PCs.

When you run the job at sequence level, it takes the parameters defined at sequence level, it ignores parameters defined at job level.

Regards,
Aditya

Hi,

I want to export the table definitions.

I tried but could not succeed.

Can we achieve this using datastage ?

Hi Ray,

Thanks for the reply

What if the node names are changed, even then can i recover the data?

Can't we recover the data.

Hi, 1) Running a dataset on 4 node config file, and after the run if i change the number of nodes to 6, Can i read the data in the dataset? 2) Running a dataset on 4 node config file, and after the run if i change the node names Can i read the data in the dataset? 3) If i cant read that, how can i r...

Hi,

We are Planning to migrate 7 of our projetcs to Datstage 8, Is there any issues with Datastage 8 , what are the major issues we will be facing while migrating to Datastage 8? What is the effort Required for this?

Can you Please help me with this

Thanks in Advance
Adi

Hi ,

can anyone tell me the differences between DB2 enterprise stage and DB2 API stage.

Thanks in advance

Regards,
Aditya

Hi ,

How to run a sequential file in parallel mode ? in which mode will the sequential file run?

Thanks in Advance

Aditya