2.2.16 Operands related to detailed SQLSTATE values
- 72) pd_standard_sqlstate = Y | N
- 0904 compatibility mode: <<N>>
- Specifies whether to output detailed SQLSTATE values.
- Y: Outputs detailed SQLSTATE values.
- N: Does not output detailed SQLSTATE values.
- For details about the SQLSTATE value that is output, see the manual HiRDB Version 9 Messages.
- Notes
- Specify N when all of the following conditions are met:
- The recommended mode is applied.
- HiRDB will be upgraded from version 09-50 or earlier.
- You omit this operand or set it to N in the environment before the upgrade.
- The client environment variable PDSTANDARDSQLSTATE is omitted.
- SQLSTATE is used in a UAP or procedure.
- If you omit this operand or set it to Y when all of the above conditions are met, change settings so that the UAPs and procedures that view SQLSTATE can view detailed SQLSTATE values.