DSXchange

Only manually - and that would require you going through the registry after the uninstall with regedit and by hand exorcising all traces of DataStage.

So, it is running fine or is it not loading data into DB2? The first message is an informational message (green) only from a hashed file and is self explanitory. In other words, it's not your problem. The second one is your problem - and is unrelated to the first. Just a guess as I don't use DB2, bu...

Can anyone guide me how to maintain a single oracle session across the OCI stages in different jobs Can't be done. When the job finishes, any uncomitted records at that point are comitted. Period. You'll either need to find a way to do what you are doing all in one job or live with the 'intermediat...

Returns null from what? How are you doing your date handling / checking? Read the online help for the Status() function, it comes in very handy for date handling inside a routine and the example there is specific to date validation, from what I recall.

kcbland wrote:Ray, Kim, and Arnd are probably the only 3 people on this forum who would know how to write a purely DS BASIC solution that would work.

Ok.

(pretty sure I could give it a run for its money)

Same answer as when you asked this over in the PX forum. They are written in the Manager and that's your best resource for examples. All of the routines in there have source code, just double-click on them to see it.

See what happens when you board up a house with someone still in it?

Welcome aboard. Without going into a great deal of detail - the 'repository' is automatically created for you when you install DataStage and will live wherever the Server component is installed. In a manner of speaking, the 'engine' this all runs under is the main repository and each project you cre...

Still don't like that DOS radio button solution, eh?

In a Server job?

Please make sure you don't give PX answers when Server questions are being asked.

You could always remove the 'illegal' CPUs.

Also try Resetting the aborted job via the Director. Look for a log entry that says "From previous run...". Double-click on it and let us know what's in there - assuming it shows up in the log.

Please look at example routines supplied with product.

Manager -> Routines. Double-click to see the code.

I'm sorry, but again - why in the heck are you running around and responding to two year old posts?

Can you then please post the contents of this log message so we can see the entire error message?