ALLBASE/SQL Reference Manual (36216-90216)

ManualsBrandsHP ManualsSoftwareMPE/iX 6.5 Operating System

672 AppendixD

Standards Flagging Support

Non-standard Statements and Extensions

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

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?