DSXchange

thanks roy, I can do that but if some other application is accessing while i deleted the entire table they will get SQLCODE 100, i don't want to to that. And I am using some filter conditions joining other DB2 table prior to the updating target table, so by the time the update process i will be havi...

I have a simple job where is read the Hash fine and update the AS400 table thru a transformer stage using Key values. But the job is taking very long time to process 10000 records(Avg 17 min). Arry size is set to 50 and Transaction size to 100. Is there any way to reduce the run time. Please guide m...

Hi ArndW
I am little confused, as you said we need to provide invocation id if we run from director, but my question is if we schedule this job and it is running automatically how the system will provide unique invocation id/parameter.
Hope i am asking correct question..

Thanks,

I believe there's a FAQ on this technique in the FAQ forum

I did not find in FAQ's

Is there a way to find SQLCODE in Transformer from pregious DB2 stage?

Thanks

I tried with @INROWNUM = 0, it didn't work out..

I need to insert status of the process like start time stamp end time stamp. but sometimes souce will be empty at that time also i need to insert the status saying that the process is done.

ArndW,

I am have same situation. I have JOBSEQ-A calling JOB-B, I created JOB-B as Multi instance job, while i am testing I can provide Invocation Id, but in production how this Invocation Id will popultaed?

Do I need to make JOBSEQ-A and JOB-B as multi instance jobs?

Any help appreciated!

Thanks

Thanks Roy! This is the part of existing UtilityRunJob code and i added the code you suggested to Prepare the job (it is between START and END). Hope it works, am I missing anything.. ! JobHandle = DSAttachJob(RunJobName, DSJ.ERRFATAL) Message = DSRMessage('DSTAGE_TRX_I_0014', 'Attaching job for pro...

Hi, I have job which reads a source DB2 table and write it to a sequential file using Transformer. at the same time i am inserting a row to another target DB2 table with some status information, but if the source is empty it is not inserting a row in target DB2 table. Is there a way to do so? I trie...

Hi All, The reason i want to user Identity colum is - I have input file comes with records, i need to store them in Table assigining a unique number, when insert it generated a number i want to use this number down the line to update the records with different statuses. So, how can i achieve this in...

Hi, I have situation where i need to get the Identity Key column value for the inserted record. I could able to insert the record but I want the value of Identity column. I am using DB2 stage for this. Is there a way using After Sql in DB2 stage How to acheve this? any help is really appreciated. Th...

Hi, I have situation where i need to get the Identity Key column value for the inserted record. I could able to insert the record but I want the value of Identity column. I am using DB2 stage for this. Is there a way using After Sql in DB2 stage How to acheve this? any help is really appreciated. Th...

Thanks Duke, i will try to inplement this.

are there any sample codes which i can use.

thanks

So, we can't capture the STAGEENDTIMESTAMP or JOBLASTTIMESTAMP in the same job. Is there any way to capture STAGEENDTIMESTAMP if i have 3 transformer stages.