HP 3000 Manuals HP 3000 Manuals
Non-standard Statements and Extensions
The following tables contain ALLBASE/SQL statements and extensions and
indicate whether they are compliant with FIPS 127.1. If the ALLBASE/SQL
statement is not compliant, the extensions to that statement are not
compliant and are therefore not included in the table. A compliant
statement may also have non-compliant extensions. These extensions are
shown as non-compliant in the table.
Table D-1. ALLBASE/SQL FIPS 127.1 Compliance
-------------------------------------------------------------------------------------
| | | | |
| ALLBASE/SQL | FIPS 127.1 | Extension | FIPS 127.1 |
| Statement | Compliant | to Statement | Compliant |
| | Statement? | | Extension? |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| ADD DBEFILE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| ADD TO GROUP | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| ADVANCE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| ALTER DBEFILE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| ALTER TABLE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| BEGIN | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| BEGIN ARCHIVE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| BEGIN DECLARE SECTION | YES | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| BEGIN WORK | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| CHECKPOINT | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| CLOSE | YES | Using | NO |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| COMMIT ARCHIVE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| COMMIT WORK | YES | RELEASE | NO |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| CONNECT | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| CREATE DBEFILE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| CREATE DBEFILESET | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| CREATE GROUP | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| CREATE INDEX | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| CREATE PARTITION | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| CREATE PROCEDURE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| CREATE RULE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| CREATE SCHEMA | YES | TableDefinition | YES |
| | | | YES |
| | | ViewDefinition | NO |
| | | | NO |
| | | IndexDefinition | NO |
| | | | NO |
| | | ProcedureDefinition| NO |
| | | | YES |
| | | RuleDefinition | |
| | | | |
| | | CreateGroup | |
| | | | |
| | | AddToGroup | |
| | | | |
| | | GrantStatement | |
| | | | |
-------------------------------------------------------------------------------------
Table 1.1. ALLBASE/SQL FIPS 127.1 Compliance (Cont)
-------------------------------------------------------------------------------------
| | | | |
| ALLBASE/SQL | FIPS 127.1 | Extension | FIPS 127.1 |
| Statement | Compliant | to Statement | Compliant |
| | Statement? | | Extension? |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| CREATE TABLE | Only when used in | PUBLIC | NO |
| | CREATE SCHEMA | PUBLICREAD | NO |
| | | PRIVATE | NO |
| | | PUBLICROW | NO |
| | | LANG=TableLangName | NO |
| | | UNIQUE HASH ON | NO |
| | | HASH ON | NO |
| | | CONSTRAINT | NO |
| | | | NO |
| | | ConstraintID | NO |
| | | CLUSTERING ON | NO |
| | | CONSTRAINT | NO |
| | | IN DBEFileSetName1 | NO |
| | | | NO |
| | | ColumnDefinition | |
| | | | |
| | | UniqueConstraint | |
| | | | |
| | | ReferentialConstraint |
| | | | |
| | | CheckConstraint | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| CREATE TABLE | Only when used in | UniqueConstraint | NO |
| | CREATE SCHEMA | | NO |
| | | ReferentialConstraintNO |
| | | | YES |
| | | CheckConstraint | NO |
| | | | NO |
| | | ColumnDataType | YES |
| | | | YES |
| | | LongColumnType | YES |
| | | LANG=ColLangName | NO |
| | | DEFAULT | YES |
| | | | YES |
| | | Constant | YES |
| | | NULL | YES |
| | | | NO |
| | | CurrentFunction | YES |
| | | NOT NULL | NO |
| | | UNIQUE | NO |
| | | PRIMARY KEY | |
| | | REFERENCES | |
| | | RefTableName | |
| | | CONSTRAINT | |
| | | ConstraintID | |
| | | CHECK | |
| | | Case Sensitive | |
| | | IN DBEFileSetName3 | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| CREATE TEMPSPACE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| CREATE VIEW | Only when used in | ColumnName | YES |
| | CREATE SCHEMA | WITH CHECK | YES |
| | | OPTION | NO |
| | | CONSTRAINT | NO |
| | | ConstraintID | |
| | | IN DBEFileSetName | |
| | | | |
-------------------------------------------------------------------------------------
Table 1.1. ALLBASE/SQL FIPS 127.1 Compliance (Cont)
-------------------------------------------------------------------------------------
| | | | |
| ALLBASE/SQL | FIPS 127.1 | Extension | FIPS 127.1 |
| Statement | Compliant | to Statement | Compliant |
| | Statement? | | Extension? |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DECLARE CURSOR | YES | IN DBEFileSetName | NO |
| | | FOR UPDATE OF | NO |
| | | ColumnName | NO |
| | | FOR READ ONLY | YES |
| | | | NO |
| | | QueryExpression | NO[REV BEG] |
| | | | |
| | | ExecuteProcedureName |
| | | | |
| | | ExecuteStatementName |
| | | | |
| | | SelectStatementName| |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DELETE | YES | WITH AUTOCOMMIT | NO[REV END] |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DELETE WHERE CURRENT | YES | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DESCRIBE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DISABLE RULES | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DISCONNECT | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DROP DBEFILE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DROP DBEFILESET | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DROP GROUP | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DROP INDEX | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DROP MODULE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DROP PARTITION | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DROP PROCEDURE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DROP RULE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DROP TABLE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DROP TEMPSPACE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| DROP VIEW | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| ENABLE AUDIT LOGGING | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| ENABLE RULES | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| END DECLARE SECTION | YES | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| EXECUTE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| EXECUTE IMMEDIATE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| EXECUTE PROCEDURE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| EXTRACT | NO | | |
| | | | |
-------------------------------------------------------------------------------------
Table 1.1. ALLBASE/SQL FIPS 127.1 Compliance (Cont)
-------------------------------------------------------------------------------------
| | | | |
| ALLBASE/SQL | FIPS 127.1 | Extension | FIPS 127.1 |
| Statement | Compliant | to S tatement | Compliant |
| | Statement? | | Extension? |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| FETCH | YES | BULK | NO |
| | | INTO | YES |
| | | HostVariableSpec | YES |
| | | USING clause | YES |
| | | [SQL]DESCRIPTOR | NO |
| | | | YES |
| | | HostVariableSpec | |
| | | INDICATOR | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| GENPLAN | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| GRANT | Only when used in | ALL (without the | NO |
| | CREATE SCHEMA | PRIVILEGE | YES |
| | | QUALIFIER) | YES |
| | | SELECT | YES |
| | | INSERT | NO |
| | | DELETE | NO |
| | | ALTER | YES |
| | | INDEX | YES |
| | | UPDATE | YES |
| | | ColumnName | YES |
| | | REFERENCES | YES |
| | | ColumnName | NO |
| | | | NO |
| | | TableName | YES |
| | | | NO |
| | | TableView | NO |
| | | | NO |
| | | DBEUserID | NO |
| | | | NO |
| | | GroupName | NO |
| | | | NO |
| | | ClassName | NO |
| | | PUBLIC | NO |
| | | WITH GRANT | |
| | | OPTION | |
| | | BY | |
| | | RUN ON | |
| | | EXECUTE ON | |
| | | PROCEDURE | |
| | | CONNECT | |
| | | DBA | |
| | | RESOURCE[REV BEG] | |
| | | MONITOR | |
| | | INSTALL[REV END] | |
| | | DBEFileSet | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| INCLUDE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| INSERT | YES | BULK | NO |
| | | | YES |
| | | SingleRowValues | NO |
| | | | |
| | | BulkValues | |
| | | | |
-------------------------------------------------------------------------------------
Table 1.1. ALLBASE/SQL FIPS 127.1 Compliance (Cont)
-------------------------------------------------------------------------------------
| | | | |
| ALLBASE/SQL | FIPS 127.1 | Extension | FIPS 127.1 |
| Statement | Compliant | to Statement | Compliant |
| | Statement? | | Extension? |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| INSERT SingleRowValues | YES | NULL | YES |
| | | USER | NO |
| | | | YES |
| | | HostVariable | YES |
| | | INDICATOR | NO |
| | | ? | NO |
| | | | NO |
| | | :LocalVariable | NO |
| | | | NO |
| | | :ProcedureParameter| NO |
| | | | YES |
| | | ::Built-inVariable | YES |
| | | | YES |
| | | ConversionFunction | YES |
| | | | YES |
| | | CurrentFunction | YES |
| | | + | NO |
| | | - | NO |
| | | | |
| | | Integer | |
| | | | |
| | | Float | |
| | | | |
| | | Decimal | |
| | | | |
| | | 'CharacterString' | |
| | | 0xHexadecimalString| |
| | | LongColumnString | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| LOCK TABLE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| LOG COMMENT | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| OPEN | YES | KEEP CURSOR | NO |
| | | WITH LOCKS, | NO |
| | | WITH NOLOCKS | NO |
| | | USING clause | NO |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| PREPARE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| RAISE ERROR | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| REFETCH | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| RELEASE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| REMOVE DBEFILE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| REMOVE FROM GROUP | NO | | [REV BEG] |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| RENAME | NO | | [REV END] |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| RESET | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| REVOKE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| ROLLBACK WORK | YES | TO | NO |
| | | RELEASE | NO |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| SAVEPOINT | NO | | |
| | | | |
-------------------------------------------------------------------------------------
Table 1.1. ALLBASE/SQL FIPS 127.1 Compliance (Cont)
-------------------------------------------------------------------------------------
| | | | |
| ALLBASE/SQL | FIPS 127.1 | Extension | FIPS 127.1 |
| Statement | Compliant | to Statement | Compliant |
| | Statement? | | Extension? |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| SELECT | YES | BULK | NO |
| | | ORDER BY | YES |
| | | | YES |
| | | ColumnID | YES |
| | | ASC | DESC | YES |
| | | | YES |
| | | QueryBlock | YES |
| | | | YES |
| | | (QueryExpression) | YES |
| | | UNION | YES |
| | | ALL | YES |
| | | DISTINCT | YES |
| | | INTO | YES |
| | | WHERE | NO |
| | | SearchCondition1 | NO |
| | | GROUP BY | NO |
| | | GroupColumnList | NO |
| | | HAVING | NO |
| | | SearchCondition2 | |
| | | NATURAL JOIN | |
| | | INNER JOIN | |
| | | LEFT JOIN | |
| | | RIGHT JOIN | |
| | | OUTER JOIN | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| SET CONNECTION | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| SET CONSTRAINTS | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| SET DEFAULT | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| SET DML ATOMICITY | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| SET MULTITRANSACTION | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| SET PRINTRULES | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| SET SESSION | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| SET TRANSACTION | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| SET USER TIMEOUT | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| SETOPT | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| SQLEXPLAIN | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| START DBE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| START DBE NEW | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| START DBE NEWLOG | NO | | |
| | | | |
-------------------------------------------------------------------------------------
Table 1.1. ALLBASE/SQL FIPS 127.1 Compliance (Cont)
-------------------------------------------------------------------------------------
| | | | |
| ALLBASE/SQL | FIPS 127.1 | Extension | FIPS 127.1 |
| Statement | Compliant | to Statement | Compliant |
| | Statement? | | Extension? |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| STOP DBE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| STOREINFO | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| TERMINATE USER | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| TRANSFER OWNERSHIP | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| TRUNCATE TABLE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| UPDATE | YES | 'LongColumnIOString' NO |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| UPDATE STATISTICS | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| UPDATE WHERE CURRENT | YES | 'LongColumnIOString' NO |
| | | NULL | YES |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| VALIDATE | NO | | |
| | | | |
-------------------------------------------------------------------------------------
| | | | |
| WHENEVER | YES | SQLERROR | YES |
| | | SQLWARNING | NO |
| | | NOT FOUND | YES |
| | | STOP | NO |
| | | CONTINUE | YES |
| | | GOTO Label | YES |
| | | : (colon; not required) |
| | | | |
-------------------------------------------------------------------------------------