Parameter Size
Welcome to our Knowledge Base
Documentation | Blog | Demos | Support
< All Topics
Print
Parameter Size
5 out of 5 stars
1 rating
5 Stars | 100% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
parameter size nn
where nn specifies the maximum size of any single IN-type parameter or local variable used in an application program’s procedures.
IN parameters and local variables are stored internally as VARCHAR variables with a maximum size of nn. If the size of any IN parameters or local variables is larger than the default value of nn, increase nn. Conversely, if all parameters are significantly smaller than the default size, reduce nn to save memory.
Valid Settings
nn = numeric entry 0 to 32000
Windows | 256 |
UNIX | 256 |
Updated
ByJason Lee
Was this article helpful?
5 out of 5 stars
1 rating
5 Stars | 100% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
5