HPlogo ALLBASE/SQL Reference Manual: HP 3000 MPE/iX Computer Systems > Appendix D Standards Flagging Support

Non-standard Statements and Extensions
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		 
 

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 TableDefinitionViewDefinitionIndexDefinitionProcedureDefinitionRuleDefinitionCreateGroupAddToGroupGrantStatement YES YES NO NO NO NO NO YES
CREATE TABLE Only when used in CREATE SCHEMAPUBLIC PUBLICREAD PRIVATE PUBLICROW LANG=TableLangName UNIQUE HASH ON HASH ON CONSTRAINT ConstraintID CLUSTERING ON CONSTRAINT IN DBEFileSetName1ColumnDefinitionUniqueConstraintReferentialConstraintCheckConstraint

NO NO NO NO NO NO NO NO NO NO NO NO NO NO

CREATE TABLE Only when used in CREATE SCHEMA UniqueConstraintReferentialConstraintCheckConstraintColumnDataTypeLongColumnType LANG=ColLangName DEFAULT Constant NULL CurrentFunction NOT NULL UNIQUE PRIMARY KEY REFERENCES RefTableName CONSTRAINT ConstraintID CHECK Case Sensitive IN DBEFileSetName3

NO NO NO YES NO NO YES YES YES NO YES YES YES YES NO YES NO NO

CREATE TEMPSPACE NO   
CREATE VIEW Only when used in CREATE SCHEMA ColumnName WITH CHECK OPTION CONSTRAINT ConstraintID IN DBEFileSetName

YES YES NO NO

DECLARE CURSOR YES IN DBEFileSetName FOR UPDATE OF ColumnName FOR READ ONLY QueryExpressionExecuteProcedureNameExecuteStatementNameSelectStatementName

NO NO NO YES NO NO

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 INTO HostVariableSpec USING clause [SQL]DESCRIPTOR HostVariableSpec INDICATOR

NO YES YES YES NO YES

GENPLAN NO   
GRANT Only when used in CREATE SCHEMA ALL (without the PRIVILEGE QUALIFIER) SELECT INSERT DELETE ALTER INDEX UPDATE ColumnName REFERENCES ColumnNameTableNameTableViewDBEUserIDGroupNameClassName PUBLIC WITH GRANT OPTION BY RUN ON EXECUTE ON PROCEDURE CONNECT DBA RESOURCE MONITOR INSTALL DBEFileSet

NO YES YES YES NO NO YES YES YES YES YES NO NO YES NO NO NO NO NO NO NO NO 4NO

INCLUDE NO   
INSERT YES BULK SingleRowValuesBulkValuesNO YES NO
INSERT SingleRowValues YES NULL USER HostVariable INDICATOR ? :LocalVariable:ProcedureParameter::Built-inVariableConversionFunctionCurrentFunction + - IntegerFloatDecimal'CharacterString' 0xHexadecimalString LongColumnString YES NO YES YES NO NO NO NO NO NO YES YES YES YES YES YES NO NO
LOCK TABLE NO   
LOG COMMENT NO  
OPEN YES KEEP CURSOR WITH LOCKS, WITH NOLOCKS USING clauseNO NO NO 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 RELEASE NO NO
SAVEPOINT NO   
SELECT YES BULK ORDER BY ColumnID ASC | DESC QueryBlock(QueryExpression) UNION ALL DISTINCT INTO WHERE SearchCondition1 GROUP BY GroupColumnList HAVING SearchCondition2 NATURAL JOIN INNER JOIN LEFT JOIN RIGHT JOIN OUTER JOIN

NO YES YES YES YES YES YES YES YES YES YES YES YES NO NO NO NO 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' NULL NO YES
VALIDATE NO   
WHENEVER YES SQLERROR SQLWARNING NOT FOUND STOP CONTINUE GOTO Label : (colon; not required)YES NO YES NO YES YES NO

 



Introduction
  		 


Non-Standard Data Types  
Feedback to webmaster