DSXchange

This is strange. I dont know if this is specific to OCI. I have never had that problem before, but then again i have not used the OCI stage. Just as a test, try with DRS stage if you have an odbc set up. Also, try to check the length, if for zero amount the len() function returns 3 then you are ok e...

You sure the length is set to 10 and the scale to 2 in the OCI stage and the hashed file stage?

Bingo, Craig is the saviour of the day.
So you were using DSJobRun() huh? And all this while i was under the impression that you were using the Utility. Because the utility is smart enough to wait for the job.

Show me the syntax of your UtilityRunJob(). Just copy paste the derivation for me.
Also, i just tested your scenario out, it works perfectly fine for me.
Also go into the job log of your Sequence job and check out its status in the last run. After the first run, somehow its not in a runnable state.

Show me the syntax of your UtilityRunJob(). Just copy paste the derivation for me.
Also, i just tested your scenario out, it works perfectly fine for me.
Also go into the job log of your Sequence job and check out its status in the last run. After the first run, somehow its not in a runnable state.

You dont need to make the job multiinstance now. Take the multiinstance out. If you still want to make it multi instance, make sure you are sending in unique Invocation Ids. Also, did your jobs for the first value from the csv execute successfully? If it did, then why is it saying that its not in a ...

Did you make sure that the director is not open during that time, specifically a monitor window or the log file. If yes, then just as a debugging attempt, remove the name of the sequence job from your main job, put some dummy jobs name. Close it and then try to recompile the sequence jobs. They shou...

You cannot use ver. 7.5.1 client to connect to 6.0 server. For more clarification, refer to this post.

YOu are either monitoring that job or the log file for that job is open. Get rid of either. You should be fine then.

Try

You need to post in the correct forum. Also, this question is on the same lines as your other question. Please refer to Ken's reply in your other post.

Is the converting Value always going to be from second column to third column. IF thats the case then the col to be calculated will always be divided by your fourth column. You dont need a routine for that. How many other possible conversions are there?

Datastage is metadata driven, as so i have heard time and again. So it would be advisable to do this kind of manipulation outside datastage to make the file ready for datastage to pickup. Like maybe a shell script that detects what columns are missing and then accordingly adds it. This way you can c...

Are those two seperate commands ?
To run multiple commands you need a semicolon in between.

dont use "string" Try this to put a new line echo "\n" > filename.txt use it exactly like that without using double quotes around the entire command. Just use it around \n. It will work. I just tested it. If its is putting \n in the output, i mean literally, then i think you are using /n i...