Creating New SQL Data Tables › Create Table Syntax Generated by CA Culprit

Create Table Syntax Generated by CA Culprit

Information from the OUTPUT parameter and the EDIT parameters is used to generate SQL Create Table syntax during the compile phase of CA Culprit. To help illustrate this correspondence, a CA Culprit program fragment is included below along with the SQL commands that are generated:

CA Culprit Syntax

 col. 2
 ▼
 010 ZERO  0
 01OUT     SQLTABLE=INVENTORY  TYPE=CREATE
*          DICTIONARY=TSTDICT  SCHEMA=INV
 0151*010  WAREHOUSE      SZ=10  NOT NULL
 0151*020  PRODUCT_CODE   SZ=10  NOT NULL
 0151*030  UNITS_ON_HAND  FP     SZ=4
 0151*031  ZERO           FB     SZ=4

Compile-phase SQL Syntax

CONNECT TO TSTDICT;
SET SESSION CURRENT SCHEMA "INV";
CREATE TABLE "INVENTORY"
        ("WAREHOUSE"     CHAR(0010)  NOT NULL,
         "PRODUCT_CODE"  CHAR(0010)  NOT NULL,
         "UNITS_ON_HAND" DECIMAL(0007,0000));
COMMIT RELEASE;

These SQL commands are generated and issued directly by CA Culprit; nothing is required of the user.