DSXchange

In particular it's not a DataStage problem. Some row that you've sent to Oracle to be loaded into a table has been rejected by Oracle because a UNIQUE (and/or PRIMARY KEY) constraint has been violated. The error message gives the name of the constraint. The UNIX-level command oerr can sometimes prov...

There isn't a "SQL Server plugin" for SELECT, so you use ODBC or OLEDB stage type. So you can happily use "Call Stored Procedure" as the method for retrieving data. Calling a Stored Procedure before retrieving data is a different problem entirely, and not really supported directly by DataStage. Sinc...

This typically means that the "ROOT" record for the job has become inaccessible. It may be inaccessible because the index for DS_JOBOBJECTS in the repository is in need of re-building, it may be inacccessible because it's been inadvertently deleted or failed to be written (have you had any "disk ful...

You could create a multi-instance job (perhaps use the BU as invocation ID) supplying the appropriate BU job parameter value for each invocation. Execute them from a job sequence that feeds each parameter value appropriately. Each job processes only the data for its particular BU; it's best to ensur...

Had a similar experience only two weeks ago. DS_JOBOBJECTS and VOC had both been corrupted (backward link errors) as well as a couple of less important tables. Given that it was fairly early in the work day, the easiest (fastest) solution was to delete the project (this always works!), create a repl...

That IS mysterious! I don't suppose there's a constraint in the first Transformer that specifies (@OUTROWNUM > 1)? (Didn't think so, but had to ask.) Deep cogitation required.

Did you do exactly as I asked? Six stage variables initialized to "" (svColumn1 through svColumn6) Six stage variable derivations. For example svColumn3 is derived as svColumn3 : (If @INROWNUM = 3 Then InLink.Line Else "") (maybe you omitted the "svColumn3 :" thinking it was a label) Six output colu...

Is there perhaps a firewall? The DataStage RPC servicce listens on port number 31538 and the DataStage telnet service listens on port number 23; you may need to open these.

Is the message the same from an attempt to connect via telnet as it is from a DataStage client?

Process it with a DataStage job that reads the whole of each line from the text file as a single column, and includes a Transformer stage that generates the six column values. Derive the six column values in six stage variables initialized to "" with derivation expressions of the form shown in this ...

SQLSTATE is specific to ODBC. Values of SQLSTATE are defined in the ODBC standard, and returned only if ODBC protocols are in use (note that some "native" protocols actually sit on top of or mimic ODBC protocols). SQLSTATE is typically generated by the ODBC driver or the ODBC driver manager. DBMSCOD...

What error message is issued when you fail to connect?

Can you ping the server machine successfully from any of the client machines?

Can you connect via telnet to the server machine from any of the client machines?

Is the DataStage RPC process (dsrpcd) running on the server machine?

The rejects output link from the Transformer stage is like any other; it can feed another Transformer stage, a text file, a database stage, and so on. Choose from any of these methods for segregating classes of error code. You can get a list of DBMS error codes from your DBMS documentation or on-lin...

Have you put the user(s) into the group?

Yes, it's a separate licence code for PX on Windows and PX on UNIX. And it's different from the server licence codes.

I use a number of utility routines such as IsNumeric, IsInteger, IsSignedInteger, IsUnsignedInteger, IsDateStr, IsDateStrOrZero, and so on.
These are a worthwhile addition to any developer's toolkit.
Might get around to parking them in the ADN files area one day.