int
scratchPadLength, in Class DB2Function
Documentation
If this is null or empty or a string value other than 1..32767, then
NO SCRATCHPAD
otherwise there will be
SCRATCHPAD <length>
where the default is 100, the same as if no length was specified.
NO SCRATCHPAD or SCRATCHPAD length
This optional clause may be used to specify whether a scratchpad is to be
provided for an external function. (It is strongly recommended that
user-defined functions be re-entrant, so a scratchpad provides a means for
the function to "save state" from one call to the next.)
SCRATCHPAD is not supported for PARAMETER STYLE JAVA functions.
| Export Control | PublicAccess | Containment | Unspecified |
| Static | No | Derived | No |
Property Settings
Data Modeler
| dmItem | False | DMName | |
| Ordinal | 0 | IsIdentity | False |
| IsUnique | False | NullsAllowed | False |
| Length | 0 | Scale | 0 |
| ColumnType | Native | ForBitData | False |
| DefaultValueType | | DefaultValue | |
| SourceId | | SourceType | |
| OID | False | | |