USE FOR DYNAMICRULES field (DYNRULS DECP value)
The DYNRULS DECP value specifies whether Db2 is to use the application programming default values that are specified on this panel. The other option is to use the values of the Db2 precompiler options for dynamic SQL statements that are bound by using DYNAMICRULES bind, define, or invoke behavior.
| Acceptable values: | YES or NO |
|---|---|
| Default: | YES |
| Update: | not recommended |
| dsnhdecp: | DYNRULS |
- YES
- Db2 uses
the application programming defaults for these fields regardless of
the DYNAMICRULES option:
- DECIMAL POINT IS
- STRING DELIMITER
- SQL STRING DELIMITER
- MIXED DATA
- DECIMAL ARITHMETIC
- NO
- Db2 uses the Db2 precompiler values for dynamic SQL statements in plans or packages that are bound by using the DYNAMICRULES bind, define, or invoke behavior.