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.