DSXchange

I get the subject message whenever I try to add a character set map in the Administrator client.

NLS is enabled and several maps have already been loaded.

Do I need admin privileges to add a map for a project?

Yes you do.

The reason is that adding a map has to edit a script that affects shared memory (in particular the segment that holds the maps), and to run a utility to "build" the map from data records contained in the NLS database.

It's all in the DataStage NLS manual.

Not sure why you get the message about removing the UV account LOGIN record; I guess the "build" script does that to guarantee clean access to TCL.

Thanks for your timely response. Another question, though.

Is there anyway of knowing whether the characters '软件' are part of any character set?

I'm suspecting GB2312.

This really should be a separate thread!

You can apply the UniSeq() function. If you get a valid integer result, then your map is correctly set. Otherwise it isn't.

The ultimate answer is to get a copy of the Unicode reference manual from The Unicode Consortium - this contains all known characters that can be mapped into Unicode.