Introduction › CA Datacom/DB Extensions

CA Datacom/DB Extensions

The CA Datacom/DB implementation of SQL conforms to American National Standard Database Language SQL, ANSI X3.135-1989 in the following manner:

1. Full SQL conformance to level 2, except as noted.
2. Includes implementation of the following facilities:
   1. Direct processing of SQL data manipulation language statements.
   2. Embedded SQL COBOL and PL/I.

In some instances, the SQL implementation described in this manual has added capabilities beyond the SQL standard. CA Datacom/DB extensions to ANSI standard SQL are indicated in the label of the syntax diagram's box (if the entire diagram represents a CA Datacom/DB extension), or within the diagram as shown below (if only part of a diagram represents a CA Datacom/DB extension).

►►─ STATEMENT ─┬───────────┬──────────────────────────────────────────────────►◄
               └─ CLAUSE1 ─┘

Note: CLAUSE1 is a CA Datacom/DB extension.

You can choose to use the CA Datacom/DB extension, which is essentially an optional parameter. Some of these extensions are unique to the CA Datacom/DB environment and could function differently from syntactically similar extensions provided by other implementations of SQL.