DSXchange

Is there a way to make a list of the Datastage projects and the NLS-project-default for eacht project?

We have about 100 Datastage projects and want to check which project is using which NLS setting.

Not easily. You could do it with a routine, or a shell script. You need to read the control record \\NLS from the DS_JOBS hashed file in each project.

Field #6 contains the default NLS map settings (server then parallel), field #7 contains the five default locale settings (server then parallel for each), and field #8 contains the default resource language setting. The first two of these are multi-valued fields, just to make life a little more awkward, and each value in field #7 contains two sub-values.

How can I read the control record from the DS_JOBS hashed file?

It's a hashed file, so in DataStage BASIC you can open it with OPEN, read it with READ and close it with CLOSE statements. The key to the control record is, from memory '\\NLS'.

If you want to work from an operating system command you can use UVread while attached to the project directory. Syntax in this case would be

I got that working. Thanks a lot!