DSXchange

kim, you are right, I forgot";" in my code.

Thanks for your all advices.

xiong

Hi, I have a universe table containing log information, I want to delete records from it in terms of Batch job name, I tried the following code ************************************************* JobHandle = DSJ.ME JobName = DSGetJobInfo(JobHandle,DSJ.JOBNAME) Cmd = "DELETE FROM BJOB_STATUS WHERE...

Great, thanks, Ray.

xiong

I am urgent to know how to to process mutiple instances of a single job in the control , this time. I just want a unique/randomized invocation id to take care of have a job available to process data. For testing reason, I created a simple job control function as below : *****************************...

I have received your mail.

Thank you very much, kenneth

xiong

I haven't received any email from you, did you send it out ?

Thanks, kenneth

xiong

Hi, Kenneth I want to run multiple instances because I am going to partition a source data set and run N number of jobs to tackle the data Actually, I have programmed a function to run a list of batched jobs. however, as the individual jobs living in the batch can only log a warning message in the c...

Thank you, kenneth. I am going to run these multiple instances from a After-job subroutine. So, could you please give me more detail example about the syntax ?

xiong

Hi, all

I wonder if i am able to run a job in multiple instances simultaneously with different parameters ? how to handle it ?

Many thanks in advance.

Xiong

Hi, I have a job process about 5 million records, it took nearly 3 hrs. But datastage issue a warning message as below: DataStage Job 2358 Phantom 4408 Date/time stamp in file header has been modified! Date/time stamp in file header has been modified! Date/time stamp in file header has been modified...

Thanks for your advices, Ray. I misunderstood some concepts. now I have made this routine work.

cheers, xiong

Hi, I am trying to select all DS job names of my project into a universe table, then I am able to handle this table in datastage job. I tried to do it by using Datastage transform function, the following is the script I wrote : ---------------------------------------------------------------------- O...

Hi, Folks I have hash file issue need your advice : I have a daily running job populate table t1 and t2 with the same 4 millions records. All data will be kept for 3 month, hence the estimated number of records for these tables will grow up to about 240 millions. t2 is used as lookup to check the so...