DSXchange

Use the GUI, i.e. the Director.

-wait returns 'normal' exit status codes: 0 for success, non-zero for failure. -jobstatus returns the same code as used internally: 1 = Finished OK, 2 = Finished (see log), 3 = Aborted, etc etc.

It's enough as long as you understand the difference between "-wait" and "-jobstatus". Did you read the documentation?

It's all documented in the Server Job Developer's Guide in the Command Line Inteface chapter. Use either "-wait" or "-jobstatus" depending on how you want the exit status handled.

Without one of the 'wait' options on the command line, it will fall squarely into your "exits immediately" camp.

Interesting. I wonder if the 'ClickPack' for DataStage is still available? It was free for the asking and brought Perl support into the product. Amongst other things.

Ok, that's one part of the puzzle. Now just need to get a better idea what your requirements are, so why don't you lay that out for us?

You'd have to uncheck that 'First line is column names' option if you want to transfer them as data in the FTP stage.

While this is generally not a problem, you can change the Data Element to XML to prevent that from happening.

Are you a UNIX Admin? Root access is not a sword to be wielded lightly and I'm leery of giving you instructions that could potentially be lethal to your server. Never mind the fact that we don't know your O/S nor what software is installed there.

Find a SysAdmin and talk to them.

An ORA "600" is a catch-all fairly nasty error. As noted, only your DBA can help you out on that one.

'Lookup Table' means what? Hashed file, database or ?

Oh, I thought the macro wrote the speadsheet out as a csv so you could 'read' it. Unless someone can tell you how to run it, perhaps incorporate the macro's logic into the DataStage job?

Also check for differences in the ODBC setups done in each environment.

Talk to your SysAdmin about clearing ports like that, see what tools are available for your O/S. They typically take 'root' access to use, so they would more than likely need to help in the process.