EXTENDEDINDICATOR bind option

The EXTENDEDINDICATOR option determines whether Db2 recognizes extended indicator variables when the associated package is run.

EXTENDEDINDICATOR

Command option Option values Used with
EXTENDEDINDICATOR
  • (NO)
  • (YES)
Note:
  1. The EXTENDEDINDICATOR bind option is not valid for REBIND of packages for native SQL procedures, native REST services, or advanced triggers.
EXTENDEDINDICATOR(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.
EXTENDEDINDICATOR(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.

Default values for EXTENDEDINDICATOR

Process Default value
BIND PLAN N/A
BIND PACKAGE NO
REBIND PLAN N/A
REBIND PACKAGE Existing value

Catalog records for EXTENDEDINDICATOR

See the EXTENDEDINDICATOR column in SYSPACKAGE catalog table.