SQL processing options for dynamic statements

Generally, dynamic statements use the application programming defaults specified on installation panel DSNTIPF. However, if the value of installation panel field USE FOR DYNAMICRULES is NO and DYNAMICRULES bind, define, or invoke behavior is in effect, certain SQL processing options are used instead of the application programming defaults.

The following SQL processing options are used instead of the application programming defaults:

• COMMA or PERIOD
• APOST or QUOTE
• APOSTSQL or QUOTESQL
• DEC(15) or DEC(31)

For some languages, the SQL processing option defaults to a value and no alternative is allowed. If the value of installation panel field USE FOR DYNAMICRULES is YES, dynamic statements use the application programming defaults regardless of the value of DYNAMICRULES option.

For additional information on the effect of SQL processing options and application programming defaults on:

• Decimal point representation, see Decimal point representation.
• String delimiters, see Apostrophes and quotation marks as string delimiters.
• Decimal arithmetic, see Arithmetic with two decimal operands.

For a list of the DYNAMICRULES option values that specify run, bind, define, or invoke behavior, see Table 1.