DSXchange

DSWaitForJob takes a job handle (nothing more) and then waits for the job to finish. But the job does need to be running first, which is all that was meant it seemed to me.

I don't think you need to do anything special, 'rejected' records during a sqlldr session automatically go into a '.bad' file.

Did they say why they recommended this?

Windows, it would seem from both the parameters being used and the OS type as originally posted. Another assumption would be via Director, so "at" on a Windows server. Please let us know if that's not the case.

Still don't think the quotes are the issue and want to see the abort messages.

There's actually a command line import/export "istool" executable available in later patch sets for 8.1... or is it 8.1.1?

No clue. There are quite a few CORBA errors posted here, did any of them help or come close? Also looking for a clarification on this statement:

Sreedhar wrote:While exporting the jobs from a specific project

So... does that mean it works fine with other projects but not with this particular one?

Double-quoting pathnames with spaces is standard Windows stuff so shouldn't be an issue. What are the actual aborts that you get?

There's one mentioned in the linked thread. You may also have a way to handle 'special characters' like # in column names, check the connector docs. DS_ENABLE_RESERVED_CHAR_CONVERT works for Oracle.

It's documented as "standard SQL" and the specific Boolean operators and string handling it supports are documented in the Parallel Job Developer's Guide pdf.

Then perhaps you should ask the author. I doubt there is one, seemed to me if it's in the queue it can get it out.

Permissions, for one other possibility.

OK, that you should be able to make work.

How exactly are you doing the 'call via DataStage'? And please don't say 'something like', you need to post exactly like so people can help you properly.

eostic wrote:Let's first assume that you have this xml in a file by itself, and what we see below was a cut/paste from IE

The dashes in front of the tags make that a pretty good assumption.