EXTENDEDINDICATOR bind option
The EXTENDEDINDICATOR option determines whether DB2® recognizes extended indicator variables when the associated package is run.
EXTENDEDINDICATOR
| EXTENDEDINDICATOR |
|
On: BIND and REBIND
PACKAGE
|
- ( NO )
- Specifies that DB2 does not recognize extended indicator variable values. Indicator variables are normal indicator variables; negative indicator variable values are null, and positive or zero indicator variable values are non-null.
- ( YES )
- Specifies that DB2 recognizes extended indicator variable values. If you use any non-recognized indicator variable values or default or unassigned indicator variable-based values in a non-supported location, DB2 generates an error message when the bound statement is running.
Defaults:
| Process | Default value |
|---|---|
| BIND PLAN | N/A |
| BIND PACKAGE | NO |
| REBIND PLAN | N/A |
| REBIND PACKAGE | Existing value |
Catalog record: Column EXTENDEDINDICATOR of table SYSPACKAGE.
