DSXchange

Put a UV stage on the end of a stream input link. The link has one column, an integer. Derive the column as COUNT(*) (or COUNT(@ID)) and specify the hashed file name as the table name. In the Transformer stage fed by this stream input link, detect whether the value of this column is 0 (in an output ...

There is no DELETE.DF (and the I-descriptor does not need to be in the VOC file - where did you read that?). You could try reinstating the DF (verbs are VERIFY.DF and REBUILD.DF). One problem that you may have is that each of the part files has a block of data (the "partfile" block) indicating that ...

VOC is a hashed file, as stated, and can have 12 or more different record formats ranging from two fields to a theoretically infinite number. Most have between two and nine fields. That's really why you can't read it; the metadata to describe such a beast are horrendous! Why do you want to read the ...

You can not create a Stored Procedure in an ODBC stage. The ODBC stage can use an existing Stored Procedure to perform its activity, but that Stored Procedure must already exist in the database, must operate on a record set, and must have been imported into the DataStage Repository (so that the numb...

Depending on the stage type at the other end of the link, you can effect a column name change by using a column name in DataStage (maybe FRED) and its derivation referring to the real column name (table.NOTFOUND). Or your derivation can explicitly specify an alias ( for example table.NOTFOUND AS FRE...

What does your support provider say?
Have you provided them with a reproducible test case?

Because twos-complement storage is used for integers, any negative integer that is small enough can be reported as a valid unsigned integer. For example the signed TinyInt -1 (int8) has the same bit pattern as the unsigned equivalent 128 (uint8), namely "10000000". You need the IsValid test and anot...

You have no control over the metadata in the rejects link of a Sequential File stage. You get one column; the raw data record (which does not match the metadata on the input link) and its type is VarBinary. If you want to change this you need to feed it into a downstream stage in which you can chang...

Are you using the Oracle Enterprise stage or the "native" OCI stage? Can you post the actual SQL that is being used? Have your DBA analyze what Oracle is doing; there may be multiple cursors interfering with each other. What happens if you run the job on a single-node configuration?

The MetaStage product includes mechanisms by which process metadata can be automatically captured whenever DataStage jobs run.

Run your DataStage jobs in MetaStage proxy mode and a listener and process Metabroker will do all the work that you're planning to do. Why re-invent the wheel?

SYSTEM requires a key of the form partno:delimiter:remainder. For example: 1/7603, 2/1311 and so on. The delimiter character is specified in the algorithm, for example SYSTEM '/' for the above keys. So, if the first column of your key can be guaranteed to contain the part numbers (1 through 10?), th...

Within DataStage use different column names. The first column in the grid replaces the parameter marker :1, the second replaces :2, and so on. Make sure that the one to appear in the WHERE clause is marked as Key. Choose user-defined SQL as the preferred method, then create the UPDATE statement that...

A is a reserved word. You need to quote the column name in double quotes if it is a reserved word or contains spaces. This is known as a "delimited identifier". SELECT "A" FROM Hash_Booking; Of course, if you want to select the literal 'A' from every column, SQL rules mandate single quotes...

If you have 10 hashed files (with identical record structure and some characteristic of the key that consistently identifies a part file) then you can construct a Distributed file. However, your partitioning algorithm only specifies a two part Distributed file. Which do you want; two or 10 parts? Im...

The status codes are the same as for DSGetJobInfo(hJob, DSJ.JOBSTATUS). They are represented by the constants whose names begin with "DSJS." and which can be found in JOBCONTROL.H.