Summary Comparison to SQL Standard

CA IDMS SQL is based on the ISO/IEC SQL Standards endorsed by ANSI.
idmscu
CA IDMS SQL is based on the ISO/IEC SQL Standards endorsed by ANSI.
Additional Statements in CA IDMS
CA IDMS supports the following SQL statements not included in the SQL standard:
Statement category
CA IDMS extensions
Access module management
ALTER ACCESS MODULE
CREATE ACCESS MODULE
DROP ACCESS MODULE
EXPLAIN
Authorization
GRANT definition privileges
GRANT EXECUTE
REVOKE SQL definition privileges
REVOKE EXECUTE
TRANSFER OWNERSHIP
Data manipulation
DECLARE EXTERNAL CURSOR
Logical data description
ALTER CATALOG
ALTER INDEX
ALTER SCHEMA
ALTER TABLE PROCEDURE
CREATE CALC
CREATE CONSTRAINT
CREATE INDEX
CREATE KEY
CREATE TABLE PROCEDURE
CREATE TEMPORARY TABLE
DROP CALC
DROP CONSTRAINT
DROP INDEX
DROP KEY
DROP TABLE PROCEDURE
Precompiler-directive
INCLUDE
Session management
RELEASE
RESUME SESSION
SET SESSION
SUSPEND SESSION
Transaction management
SET ACCESS MODULE
Additional Parameters and Capabilities in CA IDMS
CA IDMS supports the following additional parameters and capabilities not included in the SQL standard:
Statement or component
CA IDMS extensions
Identifiers
Keywords as identifiers
Data-type
GRAPHIC data type
LONGINT data type
NUM as a synonym for NUMERIC
VARGRAPHIC data type
ROWID data type (CA IDMS generated only)
Literal
G'
double-byte-character-string-literal
'
rowid-pseudo-column
 
SQL declaration sections
Support for coding delimiters across multiple lines
Special-register
GROUP
CURRENT DATE
CURRENT TIME
CURRENT TIMESTAMP
CURRENT DATABASE
CURRENT SCHEMA
CURRENT SQLID
Aggregate-function
Column-name
without DISTINCT in the COUNT function
COMMIT WORK statement
CONTINUE parameter
RELEASE parameter
CREATE TABLE statement
IN parameter
COMPRESS parameter
ESTIMATED ROWS parameter
DECLARE CURSOR statement
GLOBAL parameter
FETCH statement
BULK parameter
Buffer
specification in the INTO parameter
INSERT statement
BULK parameter
ROLLBACK WORK statement
RELEASE parameter
SELECT statement
PRESERVE parameter
BULK parameter
WHENEVER statement
Label
without a colon
CALL parameter