List NLS project-defaults

JeroenDmt · Post by **JeroenDmt** » Thu Mar 19, 2009 2:50 am

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.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 19, 2009 3:45 am

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.

JeroenDmt · Post by **JeroenDmt** » Tue Mar 24, 2009 3:21 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Mar 24, 2009 4:09 am

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

Code: Select all

${DSHOME}/bin/UVread DS_JOBS '\\NLS'

JeroenDmt · Post by **JeroenDmt** » Tue Mar 24, 2009 4:26 am

I got that working. Thanks a lot!