Orchestrate Exception

ray.wurlod · Post by **ray.wurlod** » Fri Feb 22, 2008 3:10 am

You need to look in the record schema - either in the generated OSH or in the score - to see the C-style data types reported. Clearly string[n] corresponds to the SQL data type Char(n) while string[max=n] corresponds to the SQL data type VarChar(n). When these are ustring it means that NLS is enabled and DataStage is using Unicode (rather than ASCII) for manipulating the strings internally. If you enable the Extended column in the Columns grid you will be able to see the word "Unicode" there.

Maveric · Post by **Maveric** » Fri Feb 22, 2008 3:10 am

Think you will have to specify a length for each of these fields. Do a search on "Max length must be positive".

Maveric · Post by **Maveric** » Fri Feb 22, 2008 3:12 am

Think you will have to specify a length for each of these fields. Do a search on "Max length must be positive".

Maveric · Post by **Maveric** » Fri Feb 22, 2008 3:13 am

You already have a post on this issue here.

viewtopic.php?t=116399

Why start a new tread for the same issue?