DSXchange

The same is true of Informix, only more so - it even sends informational messages attached to the connection handle.

When is the interview?

A "thot" ? Rhymes with "zot"?

You can not even assume that. "all the CPUS work on all operators (one at a time)" is only true if you have more operators than CPUs, and that the CPUs aren't also doing other things such as managing a database server's processes. Nodes are used to govern the degree of parallelism under which your j...

Status() is still set to 0 at the end of the file. You need to exit from your loop when the ELSE clause of the ReadSeq statement is taken. One way is an EXIT statement. Look at the loop I posted earlier - it's much cleaner code. Just put your parsing logic between the WHILE and REPEAT statements.

Welcome aboard. The first thing you need to do is search - maybe here, maybe Google. Look for the SQL State value 58004. Secondly you need to specify to what kind of database you are connecting and through what stage type. Otherwise how would we know? I'm going to guess that you are using DB2 or Inf...

So, coffee is a brain laxative? Or is it lack of coffee?

I understand, without being able to test my understanding, that the SCD stage does require an output link. Of course, it could always run to a Sequential File stage that appends to /dev/null.

As to your other question, I don't know. Never tried it. Have you tried it and, if so, with what result?

You can use the stage to produce the ctl and dat files, but you would then need to move these to the Oracle server (perhaps using an FTP script) and trigger the sqlldr command on that machine (perhaps using rsh).

No, I mean try specifying "machinename\username" (not just "username") in the Attach dialog for DataStage client.

The only way you can restrict nodes to execute on specific CPUs is where those CPUs are in separate machines, and you are not executing in a grid environment. In that case you can create node pools containing just the node(s) on the machine(s) - and therefore CPU(s) - in question. There is no other ...

Can you try logging in with a qualified user name (machine\user)?

Yay!
:D

There's no such thing as a "CPU pool in each node". CPUs are totally independent of nodes. Processes are started from nodes; the operating system allocates processes to CPUs on a time-share basis. Even one process may visit several CPUs during the course of a long-running execution (but only one at ...

There is no pointer to UV.ACCOUNT in a DataStage project's VOC, as installed.

It may have been created there explicitly (for example using SETFILE) or implicitly (for example by using certain options of DS.TOOLS), but it's not there by default.