DSXchange

Check this post

Ok. Now you throw in the "Restartability" part. Anyways, now you have a few ways. Enjoy

No No you got it wrong. Your master sequence will have two job activities. Second one dependent upon the first. Say this job is called myMasterSeq. The second sequence job will have wait for file activity connected to the execute command activity stage as i described in my previous post. Fire both t...

You can mark the post resolved now.

It was discussed like half an hour ago here

How about you change your design a little bit. Design two job sequences. One will have both your job activitys connected. Second job sequence will have a wait for file activity connected to Execute Command stage. Your wait for file activity will have the same specs and the execute command stage will...

Any error messages ? Anywho, you can do 'call storedprocedure' from before/after sql.

Thats exactly what he is doing. It, technically, wont go to the next step as both Job Activity 1 and the Wait for file activity are fired in parallel. It would wait for both of them to finish to go to the next step.

What server is not responding? Did not get that. Is it the oracle server ?
Yes you can call stored procedures in the before/after tab.

Yea Whale. Unix platform doesnt have the sql server bulk loader stage.

In the expression that i provided earlier, "in.Col" is your input column. You need to replace that with your inputlink.columnname.

Welcome Aboard
Use the Field Function. Use DataStage help to see how it works.
For your problem, use this

Post the routine. How did you change it to fit your requirements.

Performance depends upon what your actually doing inside the routine and not upon multiple calls by different jobs. And Yes you can call it from different jobs, that would'nt/should'nt be a problem.

I think it does, but it only comes with OS windows. Not unix. I know thats true for server. I am assuming the same applies for px as well.