DSXchange

Your metadata doesn't match what it found in the file. Perhaps your EOR setting?

Felix, please use the Reply to topic button to post a reply, this rather than quote everything you are replying to all the time - unless appropriate, of course. I had nine posts from yesterday to clean up.

Thanks.

'Twas 9:09am and 11:44am my time but decided to wait for Ray to rise and shine.

Then as far as I know you are SOL, I'm afraid.

Start with your UC4 scheduler vendor to see what their capabilities are. Perhaps they have a plug-in or adapter or widget to execute DataStage jobs. Failing that, there's always dsjob from the command line.

What version of Windows, a supported one?

Damonsal wrote:Because of the liscensing issue, not able to view the jobs directly

Can you clarify what exactly this licensing issue is?

With the jobstatus option, that "1" return code means "Ran OK", not that it is running. Zero means running. And I stand by my diagnosis.

Post your modified script as it is obviously broken, syntax-wise.

Your script sets the variable OUT Where? I see the first mention of it in the test for success and it's not set until after the first test for it. And since it is not set, it never passes the "=1" or "=2" test so the "OUT=0" bits never run. Seems to me that's what is g...

Your error could mean you don't have two key fields defined in the target, so it didn't know what to substitute in.

Look up what the jobstatus option does for the return codes. 1 = Ran OK, for example... which you seem to be expecting. Looks like an issue with $OUT as I don't see you setting that anywhere, only testing for it.

Is that supposed to be a bump?

That's the thing, the "ExecSH" part typically doesn't fail. It successfully executes and successfully runs sqlplus, it's just the procedure itself inside the sqlplus session that fails. You'll need to do two things - make sure the the script detects the errors in the sqlplus session and th...

Sure... and they depend on you to educate / guide them.

Glad this is finally sorted out, however.

Are they sorted properly, i.e. to support the needs of the join? Does your job know that your input data sets are sorted? Dumping the score would tell you what's going on. I'll wager once you do you'll see the previous answer is "no" so it is resorting everything. Add Sort stages before th...