FLAG bind option
The FLAG option determines the messages to display during the bind process.
| Command option | Option values | Used with |
|---|---|---|
| FLAG |
|
Note:
- The FLAG bind option is not valid for REBIND of packages for native SQL procedures.
- FLAG(I)
- All informational, warning, error, and completion messages
- FLAG(W)
- Only warning, error, and completion messages
- FLAG(E)
- Only error and completion messages
- FLAG(C)
- Only completion messages
Rebinding multiple plans or packages: When your REBIND command contains an asterisk (*) and affects many plans or packages, FLAG(E) is recommended to avoid running out of message storage.
Default values for FLAG
| Process | Default value |
|---|---|
| BIND PLAN | I |
| BIND PACKAGE | I |
| REBIND PLAN | I |
| REBIND PACKAGE | I |
| REBIND TRIGGER PACKAGE | I |