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 Statement	FIPS 127.1 Compliant Statement?	Extension to Statement	FIPS 127.1 Compliant 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
		`ViewDefinition`	YES
		`IndexDefinition`	NO
		`ProcedureDefinition`	NO
		`RuleDefinition`	NO
		`CreateGroup`	NO
		`AddToGroup`	NO
		`GrantStatement`	YES
CREATE TABLE	Only when used in CREATE SCHEMA	PUBLIC	NO
		PUBLICREAD	NO
		PRIVATE	NO
		PUBLICROW	NO
		LANG=`TableLangName`	NO
		UNIQUE HASH ON	NO
		HASH ON CONSTRAINT	NO
		`ConstraintID`	NO
		CLUSTERING ON CONSTRAINT	NO
		IN `DBEFileSetName1`	NO
		`ColumnDefinition`	NO
		`UniqueConstraint`	NO
		`ReferentialConstraint`	NO
		`CheckConstraint`	NO
CREATE TABLE	Only when used in CREATE SCHEMA	`UniqueConstraint`	NO
		`ReferentialConstraint`	NO
		`CheckConstraint`	NO
		`ColumnDataType`	YES
		`LongColumnType`	NO
		LANG=`ColLangName`	NO
		DEFAULT	YES
		`Constant`	YES
		NULL	YES
		`CurrentFunction`	NO
		NOT NULL	YES
		UNIQUE	YES
		PRIMARY KEY REFERENCES	YES
		`RefTableName`	YES
		CONSTRAINT `ConstraintID`	NO
		CHECK	YES
		Case Sensitive	NO
		IN `DBEFileSetName3`	NO
CREATE TEMPSPACE	NO
CREATE VIEW	Only when used in CREATE SCHEMA	`ColumnName`	YES
		WITH CHECK OPTION	YES
		CONSTRAINT `ConstraintID`	NO
		IN `DBEFileSetName`	YES
DECLARE CURSOR	YES	IN `DBEFileSetName`	NO
		FOR UPDATE OF `ColumnName`	NO
		FOR READ ONLY	NO
		`QueryExpression`	YES
		`ExecuteProcedureName`	NO
		`ExecuteStatementName`	NO
		`SelectStatementName`
DELETE	YES	WITH AUTOCOMMIT	NO
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
FETCH	YES	BULK	NO
		INTO `HostVariableSpec`	YES
		USING `clause`	YES
		[SQL]DESCRIPTOR	YES
		`HostVariableSpec`	NO
		INDICATOR	YES
GENPLAN	NO
GRANT	Only when used in CREATE SCHEMA	ALL (without the PRIVILEGE QUALIFIER)	NO
		SELECT	YES
		INSERT	YES
		DELETE	YES
		ALTER	NO
		INDEX	NO
		UPDATE `ColumnName`	YES
		REFERENCES `ColumnName`	YES
		`TableName`	YES
		`TableView`	YES
		`DBEUserID`	YES
		`GroupName`	NO
		`ClassName`	NO
		PUBLIC WITH GRANT OPTION	YES
		BY	NO
		RUN ON	NO
		EXECUTE ON PROCEDURE	NO
		CONNECT	NO
		DBA	NO
		RESOURCE	NO
		MONITOR	NO
		INSTALL	NO
		DBEFileSet	NO
INCLUDE	NO
INSERT	YES	BULK	NO
		`SingleRowValues`	YES
`BulkValues`	NO
INSERT SingleRowValues	YES	NULL	YES
		USER	NO
		`HostVariable`	YES
		INDICATOR	YES
		?	NO
		`:LocalVariable`	NO
		`:ProcedureParameter`	NO
		`::Built-inVariable`	NO
		`ConversionFunction`	NO
		`CurrentFunction`	NO
		+	YES
		-	YES
		`Integer`	YES
		`Float`	YES
		`Decimal`	YES
		`'CharacterString'`	YES
		0`xHexadecimalString`	NO
		LongColumnString	NO
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
RENAME	NO
RESET	NO
REVOKE	NO
ROLLBACK WORK	YES	TO	NO
		RELEASE	NO
SAVEPOINT	NO
SELECT	YES	BULK	NO
		ORDER BY	YES
		`ColumnID`	YES
		ASC \| DESC	YES
		`QueryBlock`	YES
		`(QueryExpression)`	YES
		UNION	YES
		ALL	YES
		DISTINCT	YES
		INTO	YES
		WHERE `SearchCondition1`	YES
		GROUP BY `GroupColumnList`	YES
		HAVING `SearchCondition2`	YES
		NATURAL JOIN	NO
		INNER JOIN	NO
		LEFT JOIN	NO
		RIGHT JOIN	NO
		OUTER JOIN	NO
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
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
WHENEVER	YES	SQLERROR	YES
		SQLWARNING	NO
		NOT FOUND	YES
		STOP	NO
		CONTINUE	YES
		GOTO `Label`	YES
		: (colon; not required)	NO

Non-standard Statements and Extensions

Technical documentation

» Table of Contents

» Index