DSXchange

It's NOT the same warning.

Start your own post. Or wait for Craig to come along and do that for you.

It's not about whether no nulls appear in the data. This warning is driven by the metadata. You have to make the receiving columns Nullable if there is any possibility (that is, any upstream Nullable column that feeds them) of a Null arriving, even though you know there aren't any.

Those are not necessarily warnings. What else is in the log with Warning severity?

Can you get a size 15 foot into a size 10 shoe? Then why do you think a requirement to store 15 characters in a Char(10) fields is legitimate?

The Iconv() function that DataStage uses is completely internal to DataStage and is not the Linux iconv command.

It may be locked in the common repository. Try to open the job in DataStage designer to determine the identity of the lock owner. Track down that person if possible; otherwise use the Web Console for Information Server to disconnect that session.

Vincent is referring to InfoSphere Streams, another IBM product designed to process data "on the move". Research this at IBM website.

However is_date does not check for d/m/yyyy, dd/m/yyyy or d/mm/yyyy, or variants with two digit year, all if which U's regex seems to want to check. If I get time I'll verify the results this week.

Data Masking Pack is not available for version 7.5.

You can join a Warning trigger into the exception handling activities through a Sequencer.

Exception handler is only invoked for Failure.

It is not invoked for Warnings.

Have you read the DataStage DB2 Connectivity Guide ?

Neither Checksum() or CRC32() is reversible. Do your masked data need to be able to be unmasked at any time?

Investigate the IBM Optim range of products, which include the abilities to mask data and generate test data that preserve the relationships and statistics of the original data.

Check the Oracle Connectivity documentation about which forms of Oracle partitioning are supported and which are not.

What part of "you can't" was unclear?