10.3.4 Operands related to SQL specifications
- 4) pd_sql_simple_comment_use = Y | N
- Operand default value
- Default value in recommended mode: Y
- Default value in 0904 compatibility mode: N
- Specifies whether to allow simple comments in SQL statements.
- Y: Allow simple comments.
- N: Do not allow simple comments.
- Notes
- If Y is specified in this operand, operations that contain two consecutive minus signs, one representing subtraction and the other representing a unary operator, can no longer be specified without being enclosed in parentheses.
- The value of this operand determines whether simple comments are available for use during routine definition and compilation.
- When the routine is recompiled, the value of this operand must be the same as when the routine is defined. If the value of this operand is changed, and then the routine is recompiled, one of the following problems might occur:
A syntax error might occur during recompilation.
The execution results obtained from the recompiled routine might differ from those obtained before the routine was recompiled.
- The value of this operand determines how the control characters are to be handled in SQL statements to be input to the database definition utility (pddef) and whether linefeed codes are to be included in SQL statements to be output by the dictionary import/export utility (pdexp) or the command for generating a definition SQL (pddefrev). For details, see the manual HiRDB Version 9 Command Reference.