DSXchange

The default time format has two digits for the hour component. You have to use a different format, by overriding the default either explicitly in your transformation function or by changing the system-wide default. I would prefer the former.

While true that statement in no way changes the correctness of what I wrote. The hidden file (.Type30) simply serves as a flag that this directory is (contains) a dynamic hashed file.

The correct terminology is HASHED file. It's one way to implement a database table, used by various database products including UniVerse, Unidata, D3, jBase and others. DATA.30, OVER.30 are where the data are stored. These are not text files, so must not be opened with a text editor. They contain no...

My guess is that your C++ compiler is (a) the wrong one, (b) not installed, (c) not installed properly, (d) not configured properly in DataStage, or (e) not licensed properly. If none of that is the case, then the fact that the system ran out of space during compilation is a fairly good indicator of...

As soon as any of Job1, Job2 and Job3 finishes, Job4, Job5 and Job6 are started. Is that what you require? It does not seem to fit with your written description.

For DataStage engine commands, go to IBM.

If you are working with the UniVerse database product, go to Rocket Software.

Easy, really.

Locking is at record level, and is triggered by a lookup failing (that is, an expectation is established that the job will insert the record from the same Transformer stage). Do not use a private read-cache in this instance because it is pre-loaded when the job starts. Do not use a write-cache, beca...

In the very early versions of the product, the only way to invoke a Routine was through a Transform. That ceased to be the case, if I recall correctly, about version 3.0. Transforms become in-line code in the job so, if a Transform is changed, every job that uses it has to be re-compiled. However, R...

There is a suggested standard in the Installation and Upgrade Guide. DEVxxxVn through to PRODxxxVn. This convention allows for versions of projects, which may be a bit "over the top" for some sites. You may have more than one phase of testing so might consider UAT, SIT or even SIT1, SIT2 a...

This is not exactly the same topic; you should really start a new one rather than hijack an old thread. If the constraint expression specifies IsNull(InputLink.ColumnName) then NULL values will be transferred to the output. You want IsNotNull() if what you want to do is to prevent NULL from being tr...

There is no general solution, because there is an upper limit on the device width but there is no upper limit on the size of MSG.TEXT.

The column and table names mentioned in the SQL must exactly match those in the Oracle schema. I've seen this error occur when the wrong schema was specified. You might also verify that the data types specified in your DataStage job are appropriate for the values being selected.

In version 7 and earlier there was such a thing as a "QualityStage job" because DataStage and QualityStage were separate products. In version 8 they have been merged into using a single set of clients, but they are still licensed separately.

You specified the delimiter incorrectly. It must be precisely specified.