DSXchange

Ray - Any special care should be taken while clearing &PH&.

There should be a field level mapping give to you. Or look into the given buisness rules. There might be some code change involved. Somting like 1--> True; 0 --> False. Use transformer to acheive this.
And dont try acheive somting new by fiting charecters into decimal field.

So should also need to have a track of commit interval.

If needed the dataset can be 'Dump'ed into a sequential file in the same script.

Are you generating your own surrogate keys or the database is generating the keys? If the answer is yes then you could have the max(key) saved in a hashed file and then in the transformer, you could have the constraint in.key > max.key Or take a similar approach, but use @INROWNUM in the constraint...

kduke wrote:He is not human.

Perhaps humane

Yes you can check in DUMP SCORE. But if select the hash partition on the key on which you merge to the all of the links it should work. By selecting Auto it is not gaurented the right partition is selected. You can find some complaints in some earliar versions. And in most cases Roundrobin wont help...

IPC stage usually goes between two active stages to run them as two seperate processes. If you have multiple cpu's, then you will be benefited with the use of IPC stage. Try this post. Its relating to your issue. DSguru2B - I guess the link has some ...t=... thing in it which redirects back to logi...

You can find one of the recent post with the same issue. It is found that integer without precision is taken as decimal(38,10) as default. Try to edit the medata manully from DS manager and use it.

Are you looking out for a performance tuning steps for these 10 records

As mentioned earliar, if you are doing lookup it is not needed to use change capture stage. The function of ChangeCapture stage is to do a lookup internallya and do change detection and give you the result with a ChangeCode. So based on the chagne code using transformer, you can acheive the logic of...

That was just to let you know that, dsjob externalize the job call. And hence you can use the command to call the job and schedule the same in your 3rd party scheduler.

Are you sure the value of $DSJOBNAME is getting passed properly.

You can use DSExecute to execute UV commands. But its is also possible to retrive the informations like DSJobStartDate, DSJobStartTime... through DsMacro from JobSequencer itself.

What is the output stage. If it is sequential file stage, try to play with "Nullable field value" and "Default value", I guess you can acheive your need, using these option. And can avoid Modify stage as well. I dont have access right now, will let you now later.