DSXchange

Check out the use of the -file option as one way to not include credentials on the command line.

Not sure but you should be able to search here and find it. Someone else discovered this earlier and it has been "retweeted" a couple of times. And they included an example, from what I recall.

And from what I recall, for version 8.x you have to add the "-domain" option to the command line credentials.

Convert should work fine... can you post the syntax you tried?

Have no way to check this myself, but... any chance that field3 is marked as a Key field?

I don't recall the Stored Procedure stage having any kind of 'pass thru' capabilities. Input columns get mapped into the proc and output is strictly driven by the proc.

No problem, glad you got it working. If you have other issues, please start new threads and don't just dog pile on this one.

It's in $DSHOME, i.e. the DSEngine directory.

You should be able to see enough to get you much futher with this, the rest is gravy. Did you try changing it to untar to standard out? If so, what happened?

I was asking if the Server OCI stage was installed: Stage Types -> Server -> Database. Post your dsenv if you want us to check it but basically all it needs is ORACLE_HOME and your 'shared library path' to be correct.

You shouldn't have to 'register' it AFAIK. Have you verified the stage is actually installed? Check in the Manager. Have all of the dsenv changes that Oracle needs been made?

There's no official API that would allow you to rename anything outside of the GUI.

Still not sure if the "execSH stage" means the before/after job routine or the "Execute Command" stage. For whatever reason, I was assuming they meant the latter. Shouldn't really matter if the first line of the script calls out the shell needed as asserted.

Is there really such a thing as a "PX only" install? Sequence jobs use the server engine, after all. Hmmm. You may not be using them but that shouldn't mean you couldn't if you needed to. Or wanted to for a test. :? Regardless, not sure how to help without knowing how in the heck everythin...

OE != OCI, the latter is a Server stage. Are you able to use the OCI stage in a Server job? Is this something that worked before your 'migration'?