DSXchange

Split the file so that there is only one message type in each file.

If you can find a third-party UNIX-based ODBC driver for MS Access then Information Analyzer can be used to profile MS Access tables.

NOT.MATCHING is a synonym for UNLIKE in RetrieVe query language. If you like that kind of thing.

The same as it means in football (soccer) and many other sports. Do it again and there will be some form of sanction imposed.

What's on the other end of the lnk_tgtStHd link?

You will need to create a routine that tests each character individually.

You do NOT edit your post to remove the original questions.

YELLOW CARD

Use user-defined SQL in the database stage that services the reference link.

(Sparse lookup is not available for all database types.)

You can have whatever you like after an Exception Handler.

The SQL SELECT uses NOT LIKE

However the RetrieVe SSELECT (which is not SQL) does not. It can use UNLIKE, but must use pattern match wildcards rather than SQL wildcards.

Data Direct - the vendors of the drivers that ship with DataStage and other drivers. There are other vendors of ODBC drivers for UNIX - use the Internet to find them.

I've already said I'm not going there.

All the information you need is in the DataStage BASIC manual. Go ahead, build yourself and your successors a maintenance nightmare!

What have you tried? I would imagine the solution would be fairly identical in a parallel Transformer stage, though the expression to generate the sequence number may need to take account of the fact that the Transformer stage is executing on more than one node - or you could force it to execute in ...

Try 850 or even 900 as your threshold.

You can certainly copy them, but you must make sure that the data files' pathnames are exactly the same, because these pathnames are recorded in the descriptor file for the Data Set.