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). |
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. |