DSXchange

Eran - if you have information to add to this, please do so in this thread, not via private email. That way anyone can help you.

No worries, we all accidentally wander into strange territories on occasion.

That's interesting... and unfortunate. No such problem in earlier versions that I've ever heard.

VCInDSX wrote:Correct me if i am wrong, my understanding is that the "SQL Server Enterprise" is not available on Linux/Unix Server installations.

Your understanding is correct, Windows servers only.

The Command Line Interface is fully documented in either the Parallel Job Advanced Developer's Guide or the Server Job Developer's Guide. Or search the forums for 'dsjob'.

Cool... please mark the topic as Resolved then.

Welcome! Unfortunately, that routine is incomplete. All you are trapping are problems connecting to sqlplus, you'll have no clue if the sql itself didn't run problem free inside the sqlplus session unless you redirect the output and grep it for problems.

Have you checked via the Director's 'Cleanup Resources'? Set it to show all processes and look for either your job name or number, then log it out.

Add COUNT.SUP to the end of your TCL query.

Yoga - that's the way the routine works, each call to it gets you a unique number. You'll need to hash the incoming records so you know to call it only when you need a new key but use an 'old' one for the duplicates.

There's no "Remove Duplicates" stage in Server, never mind the fact that they want duplicates.

Post your job design. I don't hear anything (yet) that would lead me to think you would have locking problems.

Your C compiler, is this case MicroSoft Visual C. ++, I assume.

I'd worry more about the performance of your disk subsystem with regards to those metrics rather than raw CPU and RAM.

I have the oracle 9i client driver installed. But I am accessing a 8i database. I for one wouldn't assume any level of ok-ness here. There's no guarantee from Oracle with regards to backwards compatibility of the client. What will work is to use the client from the lowest version of the database yo...