Page 1 of 1

How to set NLS to NONE in Parallel Job?

Posted: Fri Jun 30, 2006 4:05 am
by daniel0623
Dear all,

I can set NLS to NONE in server job.But it seems DS does not support NONE in parallel job.How to disable NLS in parallel job?

Thanks for any suggestion.

Posted: Mon Jul 03, 2006 3:46 am
by Eric
If you've installed DataStage with NLS then you'll have to set a locale/code page rather than 'None' as all input files with have a code page.
Have you tried using the installed default?
What problems do you have using the NLS settings?

Posted: Mon Jul 03, 2006 4:06 am
by Klaus Schaefer
You need to define the data of type "raw" in schema,

e.g.: data:nullable raw[max=65535]

which translates into LongVarBinary in DS table definition, to have them not go through NLS mapping.

klaus