Eliminate NLS warning msg ??

[tomengers]

Hi Folks ...

We do not have or want NLS, but this Director msg just will not go away. All our jobs contain this Warning:

"main_program: The NLS character map <ISO-8859-1> is specified, but NLS_LANG is not set;
the NLS character map must be set to an ICU codepage which is equivalent to
the character set specified by NLS_LANG."

Administrator Client: NLS is grayed out
Designer Client:
Job Properties: NLS tab:
Default map for stages: Project default (ISO-8859-1)
Default collation locale for Stages: Project (OFF)
Transformer stages: Project default (OFF)
Seq file stages: Project default (ISO-8859-1)

I suspect my problem is that ISO-8859-1 setting, but the dropdown does not offer "OFF". I've poured thru the NLS posts but find nothing useable.

Any suggestions will be most appreciated.

thanks ...

... tom

[ray.wurlod]

You could just set NLS_LANG to an appropriate value. (This is the environment variable used by Oracle, for example.)

Or you could try using the NONE pseudo-map in DataStage.

[Bryceson]

We once had NLS turned ON and then turned it OFF . . . Then we're getting the same messages you're having in our jobs.

REINDEXING the PROJECT took care of the warning messages.

DS.REINDEXING ALL

I hope this will help!

Bryceson

[ray.wurlod]

Lose the "ING". The command is DS.REINDEX ALL and must only be done when you have exclusive use of the project.

[tomengers]

Thanks for the responses ... we've been told that NLS_LANG should be american_america to match the database. The character set is WE8ISO8859P1.

... tom