ALLBASE/SQL Reference Manual (36216-90216)

Appendix D 677
Standards Flagging Support
Non-Standard Syntax Rules
Non-Standard Syntax Rules
ALLBASE/SQL supports certain non-FIPS compliant extensions to the standard FIPS
syntax rules listed in the ANSI SQL/89 document. The section number, the status rule
number, and the FIPS SQL syntax rule for each non-FIPS compliant extension are listed
below.
Note that in some cases no flagger warning is generated for these exceptions.
Table D-2. FIPS Syntax Rules and ALLBASE/SQL Exceptions
Section #
Status Rule #
FIPS SQL Syntax Rule ALLBASE SQL Extension
5.3 SR 3 All identifiers must be no longer than
18 characters.
20 characters are allowed.
5.3 SR 4 No identifier may be the same as a
keyword, noting that all keywords are
specified in upper case.
Keywords are not case sensitive;
keywords can be identifiers.
5.24 SR 8 There may only be one DISTINCT per
subquery, not including any nested
subqueries.
SELECT DISTINCT MAX
(DISTINCT C1) FROM T1 is valid.
5.25 SR 5 There may only be one DISTINCT per
query, not including any subqueries in
that query.
SELECT DISTINCT MAX
(DISTINCT C1) FROM T1 is valid.
5.25 SR 11b Every <value expression> in the
<select list> consists of a <column
specification>, and no <column
specification> appears more than once
- updatability of a table/view.
It is possible to update a regular
column in a view that contains a
virtual column. (No flagger warning is
generated).
6.1 DDL commands must be used in the
CREATE SCHEMA statement.
DDL commands can be issued outside
of a CREATE SCHEMA statement.
8.6 SR 3b In a FETCH, only an exact numeric
column or expression may be
FETCHed into an exact numeric host
variable.
Compatible data and truncation are
allowed. (No flagger warning is
generated).
8.6 SR 6a An INSERT into a character column
must be a character string of length
less than or equal to the column.
Compatible data and truncation are
allowed. (No flagger warning is
generated).
8.7 SR 6b An INSERT into an exact numeric
column must be an exact numeric
value.
Compatible data and truncation are
allowed. (No flagger warning is
generated).
8.10 SR 4b In a SELECT ... INTO, only an exact
numeric column or expression may be
selected into an exact numeric host
variable.
Compatible data and truncation are
allowed. (No flagger warning is
generated).