DSXchange

Do you check with netstat that the port number is not bound? Have you started dsprcd in debug mode so as to verify why it is stopping? Have you tried "the Microsoft solution" (re-boot the server)?

Be very consistent. For example, only ever change buffer sizes on input links. Remember that larger buffers means more memory demand; if you are already limited for memory, increasing buffer sizes is contraindicated. What do you believe increasing buffer sizes (in isolation) will accomplish?

No. If you are allowed to compile you are allowed to execute.

Search for "vertical pivot" for this is what you are trying to accomplish.

It appears from the messages that QualityStage is seeking, but not finding, four classification override tables. Perhaps you could create the needed overrides, even if they do nothing, to see whether that fixes the problem.

DataStage does not deal with cursors. You need to adapt your logic into a regular SELECT statement or a call to a stored procedure. Under the covers DataStage uses "prepared SQL". For a SELECT this involves sending the SQL to the database when the stage starts, and issuing SQLFetch() calls to retrie...

The number of columns referred to in the INSERT statement is not the same as the number of columns in your DataStage job (or record schema).

Do you have runtime column propagation enabled?

(1) ANALYZE.FILE hashedfilename STATISTICS
(2) Tunables tab

The terminology is "hashed file", not "hash file".

You may need to perform a SETFILE command to establish a VOC pointer before ANALYZE.FILE command will work.

Probably the connection was refused or the RPC daemon (service) is not running. Did you check? Is port number 31538 open in the firewall? Do you have service pack 2 installed? If so, have you installed the required DataStage patch? Is your DataStage RPC service running? Note also that Windows XP is ...

(1) No. This is how it works.
(2) That was not a question.

This is not provided for in dsjob.

You could write your own variant of dsjob. Source code for the original is supplied with DataStage.

By default no. To permit error logging, create the errlog file in the DataStage home directory. Make sure it is writable by everyone. cd $DSHOME touch errlog chmod 777 errlog By default, this is a cyclic log containing at most 100 most recent entries. The number of entries is adjustable via the MAXE...

That was vital information omitted from your original post. I can only suggest close scrutiny of that stage's source code to determine how records of this type ought to be handled.

Not within the same job.

Otherwise, by dint of very careful installation and manipulation of Oracle environment variables, you may have both installed (in different locations), but you can only access one at any one time.

The Filter command field becomes enabled when the box is checked. This command is executed and its output (stdout) is read by the Sequential File stage. You can specify any command (or set of commands) as the filter command, but the rows it generates must conform to the metadata defined on the Seque...