ALLBASE/SQL Reference Manual (36216-90216)

678 AppendixD
Standards Flagging Support
Non-Standard Syntax Rules
NOTE There is one more exception to the syntax rules listed above:
No flagger warning is generated for a second reference to a non-standard
extension within the first non-standard reference.
8.11 SR 8b An UPDATE ... WHERE CURRENT
of 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.11 SR 8c In an UPDATE ... WHERE
CURRENT, only an exact numeric
value or NULL may be put in an exact
numeric column.
Compatible data and truncation are
allowed. (No flagger warning is
generated).
8.12 SR 6b A searched UPDATE of 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.12 SR 6c In a searched UPDATE, only an exact
numeric value (or NULL) may be put
in an exact numeric column.
Compatible data and truncation are
allowed. (No flagger warning is
generated).
9.2 SR 1bc COLON has to precede the host
identifier in WHENEVER.
The absence of COLON in the front of
the label is allowed.
Table D-2. FIPS Syntax Rules and ALLBASE/SQL Exceptions
Section #
Status Rule #
FIPS SQL Syntax Rule ALLBASE SQL Extension