Page 1 of 1
Limitation in Parameter size
Posted: Mon Nov 13, 2006 1:05 am
by Ocean
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
Posted: Mon Nov 13, 2006 2:29 am
by loveojha2
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).
Posted: Mon Nov 13, 2006 5:33 am
by ArndW
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.