length of the variable

parvathi · Post by **parvathi** » Tue Oct 17, 2006 6:31 am

Hi all,
I have a sceneraio like this
I store the fileNamesand the count of the records in a variable which is used in the datastage rountine
I have doubt whether is there any limit on the length of the variable
If i count all the files they come around 30 and each file name is 20 characters long
so approximately 450 charactershave to be stored in a variable

Is this possible..??

ArndW · Post by **ArndW** » Tue Oct 17, 2006 6:34 am

Is this Servre or Parallel Extender?

In Server the limit to a variable is however much virtual memory the process has (basically a very, very long string).

PX uses explicitly declared variable types and lengths.

parvathi · Post by **parvathi** » Tue Oct 17, 2006 7:44 am

thanks this is a server job

Krazykoolrohit · Post by **Krazykoolrohit** » Wed Oct 18, 2006 7:30 am

It should work fine unless you have a bug in your code. Implement this and let us know if you face any issues