STD SQL LANGUAGE field (STDSQL DECP value)

The STD SQL LANGUAGE field specifies the SQL standard that is to be used in writing application programs. Specifically, the parameter specifies whether the SQL language conforms to the portions of the 1992 ANSI SQL standard that are implemented by Db2.

Acceptable values: YES, NO
Default: NO
Update: not recommended
dsnhdecp: STDSQL
YES
The SQL language that is used in application programs conforms to the portions of the 1992 ANSI SQL standard that are implemented by Db2.
NO
Programs are written in accordance with the SQL language that is defined by Db2.