Compilation Error on NLS

Alagusakthivelan · Post by **Alagusakthivelan** » Mon Oct 09, 2006 2:04 am

I get an error like "SQL Datatype of NChar is only supported when NLS is enabled" while compiling. I need the cause for the error.

ArndW · Post by **ArndW** » Mon Oct 09, 2006 2:16 am

The cause of the error is that NChar is not supported in that stage/job when you don't have NLS enabled. Try using Char instead.

Alagusakthivelan · Post by **Alagusakthivelan** » Mon Oct 09, 2006 2:34 am

NLS is enabled in our server butstill it is showing the same error, is it particular to a job or if we have used some language settings..still that problem can come...

please give solution ASAP

ArndW · Post by **ArndW** » Mon Oct 09, 2006 2:42 am

Alagusakthivelan,

The best place to get ASAP help is your support provider. Please contact them for a quick response.

The compiler doesn't think NLS is enabled. Does this happen with just one job or with all?

ray.wurlod · Post by **ray.wurlod** » Mon Oct 09, 2006 4:47 am

Please post the full error message so we can determine its origin (that is, DataStage or your database server).