Unsupported language

<< Click to Display Table of Contents >>

Navigation:  Local SQL > Overview > Conventions >

Unsupported language

Previous pageReturn to chapter overviewNext page
hmtoggle_plus1See also

The following SQL-92 language elements are not used in local SQL.

ALLOCATE CURSOR (Command)

ALLOCATE DESCRIPTOR (Command)

ALTER DOMAIN (Command)

CASE (Expression)

CHECK (Constraint)

CLOSE (Command)

COALESCE (Expression)

COMMIT (Command)

CONNECT (Command)

CONVERT (Function)

CORRESPONDING BY (Expression)

CREATE ASSERTION (Command)

CREATE CHARACTER SET (Command)

CREATE COLLATION (Command)

CREATE DOMAIN (Command)

CREATE SCHEMA (Command)

CREATE TRANSLATION (Command)

CREATE VIEW (Command)

CROSS JOIN (Relational operator)

CURRENT_DATE (Function)

CURRENT_TIME (Function)

CURRENT_TIMESTAMP (Function)

DEALLOCATE DESCRIPTOR (Command)

DEALLOCATE PREPARE (Command)

DECLARE CURSOR (Command)

DECLARE LOCAL TEMPORARY TABLE (Command)

DESCRIBE (Command)

DISCONNECT (Command)

DROP ASSERTION (Command)

DROP CHARACTER SET (Command)

DROP COLLATION (Command)

DROP DOMAIN (Command)

DROP SCHEMA (Command)

DROP TRANSLATION (Command)

DROP VIEW (Command)

EXCEPT (Relational operator)

EXECUTE (Command)

EXECUTE IMMEDIATE (Command)

FETCH (Command)

FOREIGN KEY (Constraint)

GET DESCRIPTOR (Command)

GET DIAGNOSTICS (Command)

GRANT (Command)

INTERSECT (Relational operator)

MATCH (Predicate)

NATURAL (Relational operator)

NULLIF (Expression)

OPEN (Command)

OVERLAPS (Predicate)

PREPARE (Command)

REFERENCES (Constraint)

REVOKE (Command)

ROLLBACK (Command)

Row value constructors

SET CATALOG (Command)

SET CONNECTION (Command)

SET CONSTRAINTS MODE (Command)

SET DESCRIPTOR (Command)

SET NAMES (Command)

SET SCHEMA (Command)

SET SESSION AUTHORIZATION (Command)

SET TIME ZONE (Command)

SET TRANSACTION (Command)

TRANSLATE (Function)

UNIQUE (Predicate)

USING (Relational operator)