Maximum Number of Value Files in Parameter Set

atulgoel · Post by **atulgoel** » Mon Dec 19, 2016 3:45 am

is there any maximum limit on the number of Value Files that we can define in Parameter Set?

chulett · Post by **chulett** » Mon Dec 19, 2016 8:33 am

Isn't technically the answer 1? While you could have any number of value files created, only one at a time can be associated with a given parameter set. That's what I recall, anywho.

atulgoel · Post by **atulgoel** » Mon Dec 19, 2016 8:54 am

Thats right... At run time we can use only on value file set. But my question was.. Is there any limit on the number of value file set that we can define with one parameter set?

Hope my question is clear.

chulett · Post by **chulett** » Mon Dec 19, 2016 8:56 am

It's not... the answer may depend on what exactly you mean by "define" but as I already noted that can be "any number", i.e. there is no limit that I've ever seen or recall.

Timato · Post by **Timato** » Tue Dec 20, 2016 5:41 am

Each parameter set value defined will result in a plaintext file with the same name created in the parameter set folder (project/parameterset/<parameter set name>/<parameterset value>) on the DataStage engine file system.

So my guess would be the number of parameter sets values files will be bounded by any file system restrictions there (ie. probably none

). Personally, I have created jobs with ~100ish parameter set values with no problems, though within DS designer, opening up the parameter set editor takes a second or two longer to bring up all the values, at which i resort to just editing the parameterset values by hand in notepad.

atulgoel · Post by **atulgoel** » Fri Dec 23, 2016 6:45 am

Ok thanks... Marking this post as resolved...

ray.wurlod · Post by **ray.wurlod** » Sat Dec 24, 2016 5:10 pm

There's no practical limit.

However a very large number will introduce minor delays to the drop-down lists in the various GUIs, for example when choosing the "value" of a Parameter Set in the Job Run Options dialog.