Tip of the Day: Controlling the maximum length of RETURN variable
Section: Stored Procedures and Triggers
RETURN varname option is used ONLY within a Stored Procedure to return a value.
The returned value is stored in the STP_RETURN system variable. This option will return an -ERROR- when used outside a Stored Procedure. The default is TEXT 8 characters, but if you want more, you can set it to a larger value. You can control the maximum length at procedure definition time, or by editing the SYS_PROC_LEN column in SYS_PROC_COLS system table.
Example 01:
PUT MyTest.PRC AS MyTest P1 INTEGER RETURN TEXT (30) will set the limit for the RETURN value at 30 characters.
Very Best R:egards,
Razzak.
