Db2 Features Not Supported In The Standard.

Written by VR Saturday, 02 April 2011 19:20

SQL

The standard does not allow any characters to appear in identifiers other than the uppercase letters A-Z the digits 0-9 and the underscore character.DB2 allows the character #,@,and $ to appear in an identifier  wherever a letter can appear.DB2 also allow double byte characters to appear in identifiers and supports “delimited  identifiers”.

• DB2 allows consecutive underscore characters to appear in an identifier.The standard does not.
• The DB2 concept of system-defined default values does not exist in the standard ;the specification NOT NULL WITH DEFAULT on CREATE TABLE is a DB2 extension.
• DB2 allows a value of appropriate numeric type to be assigned to an object of exact numeric type. The standard does not.
• DB2 support hexadecimal literals.
• DB2 supports a concatenate operator.
• The standard does not include any scalar built-in functions.
• DB2  support the use of explicitly defined range variable in UPDATE and DELETE as well as in SELECT.
• The standard does not support the COMMENT or LABEL statements.
• The standard does not support synonyms.
• The standard does not support aliases.
• The standard does not support the statement SET CURRENT SQLID,SET CURRENT PACKAGESET,SET host variable and CONNECT.