DSXchange

Note how server jobs differ from parallel jobs. Server job reject links begin in a Transformer stage that feeds the Oracle stage, not from the Oracle stage itself.

I used to run a Prime 250 with 2MB memory. On eight nineteen-inch rack-mounted boards (0.25MB each).

It's fine. TIMESTAMP, were you to import the table definition for RT_LOG, would have data type Char(19). There is no intrinsic Timestamp data type in DataStage SQL - it only has DATE and TIME.

It does give you the correct result. It is incapable of doing otherwise. Justify your accusation. As you do, specify how your rows are partitioned and which columns are key columns.

The only way to capture the identity of the user of the UNLOCK command would be to wrap the command in an auditing routine. This technique is not covered in any of the DataStage documentation. Is anyone really interested? After all, once the lock is unlocked, they're off and running again. If it's d...

A job log can be accessed with a Hashed File stage or a UV stage. You can create DataStage jobs to move the data. Of course, this will involve a job sequence, because you have to generate the log file name (RT_LOGnnn, where nnn is the job number). You could also use a Sequential File stage with dsjo...

Can you please wrap your "diagrams" in Code tags, then play with Preview till you get a more comprehensible design? I can not discern what your job sequence is intended to accomplish - what goes with what.

Any version number containing "r" is a "rapid repair fix" and has not been through full Quality Assurance testing. You should contact your support provider for a version that has been through full QA testing.

Hashed files are not navigated by field name or even by position in the grid, but by position in the data record. In the Columns grid on a hashed file stage you will find a column called Position; any field (column) with Position 0 is a key, while non-key fields are numbered 1, 2, 3 and so on. Provi...

Search for "Pivot stage". Read the Pivot stage manual. You will need an upstream Transformer stage to generate the month names in twelve additional columns.

They do happen, for example when row buffering is on in server jobs and a timeout occurs, or when any of the ipc processes times out. It can also happen when reading a named pipe using a Sequential File stage. As a general rule they can be ignored.

Yes, but that's not what you need to do.

Change the first argument of DSExecute() from "UV" - which causes a DataStage command to be executed - to "DOS" - which cause the command to be executed as an operating system command.

How many jobs are there in the project? You may have hit some kind of design limit.

No. The system doesn't "find" anything. You have to provide the location and name of the hashed file. In a Hashed File stage, you provide the pathname of the directory in which the hashed file exists (or is to be created) in the Stage properties, and the name of the hashed file in the link propertie...

A project consists of three things, a directory containing the Repository objects and various other files, an entry in the UV.ACCOUNT hashed file, and various entries in the system tables for DataStage. Remove the project directory and all its contents. Remove the entry from the UV.ACCOUNT file. Get...