Limitation in Parameter size

Ocean · Post by **Ocean** » Mon Nov 13, 2006 1:05 am

Hi All,

Is there any limitation of parameter passed to Routines? What is the maximum characters that allowed to pass to routine in Server Job?

Thanks

loveojha2 · Post by **loveojha2** » Mon Nov 13, 2006 2:29 am

There should be some upper limit on the no of parameters, but should accomodate almost all of the genuine param limit.

More over no limit to the no of character that can be passed (may be 2gb, if there is any).

ArndW · Post by **ArndW** » Mon Nov 13, 2006 5:33 am

The parameters are passed in memory, so the limit will be close whatever your environment's setting for memory is set to. The 2Gb limit applies only to some OS's and their maximum file size. DataStage variables are not limited in that fashion.

More likely you will have a limitation on parameters by your maximum command line size, as the "dsjob" executable is often used to pass parameters to jobs.