ALLBASE/SQL Message Manual (36216-90213)

32 Chapter2
ALLBASE/SQL Warning Messages
CAUSE Identifier exceeds maximum allowed in ANSI SQL/89
standard.
ACTION Do not use this identifier length if portability is a concern.
1804 MESSAGE Use of multiple DISTINCTs within a query or
subquery is a
non-standard extension. (DBWARN 1804)
CAUSE Allowing multiple distincts in a query or subquery is an
ALLBASE/SQL extension to the ANSI SQL/89 standard.
ACTION Do not use this statement if portability is a concern.
1805 MESSAGE DDL statement outside a CREATE SCHEMA
statement is a
non-standard extension. (DBWARN 1805)
CAUSE ANSI SQL/89 requires DDL commands to be within a
CREATE SCHEMA AUTHORIZATION statement.
ACTION Place all DDL commands within the CREATE SCHEMA
statement if portability is a concern.
1806 MESSAGE Use of keyword as an identifier is a
non-standard extension.
(DBWARN 1806)
CAUSE Use of keywords as identifiers is an ALLBASE/SQL
extension to the ANSI SQL/89 standard.
ACTION Do not use keywords as identifiers if portability is a
concern.
1807 MESSAGE Access to SYSTEM/CATALOG tables/views is a
non-standard
extension. (DBWARN 1807)
CAUSE ALLBASE/SQL system/catalog views and tables are
non-standard objects.
ACTION Do not access these objects if portability is a concern.
1808 MESSAGE An object with owner (!) not equal to schema
name (!) is a non-standard extension. (DBWARN
1808)
CAUSE This is an ALLBASE/SQL extension to the ANSI SQL/89
standard.
ACTION Modify the syntax if portability is a concern.
2005 MESSAGE The index dropped is a clustering index.
(DBWARN 2005)
CAUSE The index you just dropped with the DROP INDEX
statement was created with the CLUSTERED attribute.
ACTION No action is necessary.