DSXchange

There are at least five different ways for generating surrogate keys which you would have discovered had you bothered to Search rather than hijacking a thread that is more than two years old.

Because of Oracle - blame Oracle bin Larry.

For example Integer maps into Oracle as NUMBER(38) which the rest of the world would understand as Decimal(38,0).

That's an alert, notifying you that a 255 character string may contain a number that is too large to load into a Decimal with precision less than 255. You could try adding a NOWARN specification, but probably will end up adding a message handler to demote this particular alert to informational. Data...

What happens if there are no quotes around the project name?

Which odbc.ini file were you using - the one in DataStage or the one in branded_odbc - when you did this test?

Was there anything useful in the trace log?

That's a completely different error. Read both error messages carefully. "Could not be found" and "Could not be loaded" are not the same thing.

Beat me to it! I'd just spotted the same thing.

How about assuming that the square brackets mean "optional" and that double-quote characters are needed for the first argument?

Welcome aboard. Learn to read everything that error messages tell you. In this particular case your configuration file (whose pathname is given by the APT_CONFIG_FILE environment variable) does not include the node name of the machine on which DataStage server is installed. I daresay you have not ed...

This should be your thought process for text files. Text files do not really have data types - only text. Therefore there can be no concept of NULL in a text file. When you specify metadata for a text file you can specify how NULL is represented, either on a field-by-field basis, or globally. If it...

Mandatory, but globally rather than for each project.

Mandatory, but globally rather than for each project.

The Metadata Delivery service is how metadata are moved to and fro between consumers (such as DataStage Server) and the XMETA database.

Does any sequential file stage in your job specify DOS-style line terminators, or process a file that was created in a Windows environment?

Ctrl-Z is the Windows end-of-file marker character.

Oracle does that.