ALLBASE/SQL Reference Manual (36216-90216)

668 AppendixD
Standards Flagging Support
Non-standard Statements and Extensions
LongColumnType NO
LANG= ColLangName NO
DEFAULT YES
Constant YES
NULL YES
CurrentFunction NO
NOT NULL YES
UNIQUE YES
PRIMARY KEY
REFERENCES
YES
RefTableName YES
CONSTRAINT
ConstraintID
NO
CHECK YES
Case Sensitive NO
IN DBEFileSetName3 NO
CREATE TEMPSPACE NO
CREATE VIEW Only when used
in CREATE
SCHEMA
ColumnName YES
WITH CHECK OPTION YES
CONSTRAINT
ConstraintID
NO
IN DBEFileSetName YES
DECLARE CURSOR YES IN DBEFileSetName NO
FOR UPDATE OF
ColumnName
NO
FOR READ ONLY NO
QueryExpression YES
ExecuteProcedureName NO
ExecuteStatementName NO
Table D-1. ALLBASE/SQL FIPS 127.1 Compliance
ALLBASE/SQL Statement FIPS 127.1
Compliant
Statement?
Extension to Statement FIPS 127.1
Compliant
Extension?