DSXchange

Don't pass such rows through the first Transformer. Add the four checks to the output link constraint expression, conjoined with AND operators.

Yes. Provided you've got metadata (typically a COBOL FD) that describes the redefinitions of a "record".

Whilst it's not in the debugging basket, I always add a sanity check to make sure that I'm doing things as efficiently as I know how, especially not processing any data unnecessarily or evaluating any expression more than once per row.

Your vendor (the company from which you purchased DataStage) is expected to provide first line support - they take a percentage of the maintenance revenue. If you bought DataStage through a reseller and then attempt to contact IBM support directly, you will be politely but firmly redirected back to ...

For just a few cents per day you can read premium posts, and help to pay for DSXchange's bandwidth.

Or is it that you're searching for the mysterious "u" cited often on DSXchange but whose identity remains to be definitively established?

Can you please execute the following command in the Administrator client command window? VLIST RT_BP869 JOB.1077009604.DT.1386139145.TRANS10 The second column contains hex addresses. Find address 0x10, and post a few statements either side of it. From that, you will be able to discern the statement ...

Thanks for the feedback. We were fairly sure the problem wasn't in the hashed file itself.

DataStage job will abort when it receives the signal from the operating system that the file size limit has been exceeded. Your data will be truncated at 4GB and may not be recoverable, as no end-of-file mark will have been written. That's one of the reasons DataStage can only be installed on NTFS p...

You need a lot more in LD_LIBRARY_PATH than that! Take a look at its value on your production machine.

Make sure, too, that the name liborchgenerali686.so is correct for the library in /applications/dsadm/Ascential/DataStage/PXEngine.751.1/lib (sometimes the final "i", part of "i686", is omitted).

During the reign of Olaf Quimby II as Patrician of Ankh some legislation was passed in a determined attempt to put a stop to this sort of thing and introduce some honesty into reporting. Thus, if a legend said of a notable hero that 'all men spoke of his prowess' any bard who valued his life would ...

"Element" is an element in a dynamic array. The output is returned to DataStage as a dynamic array (a field-mark-delimited string). The loop served to remove any empty lines (at the beginning and end, typically, from an ls output). Your solution removes only the one at the end.

In particular, address this question.

Is the date increasing automatically (and you're asking whether this is possible), or do you want the date to be incremented (which is possible, but by how much and how often)?

This is one of those occasions where you might consider using a BASIC Transformer stage and a server routine. Or write a parallel routine, if your C++ skills are up to it. In BASIC, you have the "MX0C" conversion in Oconv() that does exactly what you require for ASCII, returning two hex digits per b...

Planning and Peer Review Before you even touch DataStage, sketch out your plan of attack. Which stage types will you use, and why. Sources and targets - are their table definitions in Repository? Are any custom routines needed, or can all logic be performed using available components? Sketch out th...

No data conversions are required. Ignore all previous advice.

If your source date is in a non-default format, use either the stage properties or the column extended properties (Edit Row in the Columns grid) to override the default date format.