Identify the source of conventional file input to create an SQL table.

INPUT

Define fields from non-IDMS files to CA Culprit.

REC

Define printed output.

OUTPUT

Identify the input source as an SQL table; specify table location.

IN DB(Q);

DICTIONARY= SCHEMA=

Define the SQL query to CA Culprit.

SQL select-statement

Define an alias for an SQL column within the SQL query.

AS

Define an output data table.

OUTPUT

SQLTABLE=

TYPE=CREATE

DICTIONARY=

SCHEMA=

Name the columns in a details-only table.

Type 5 (at least one)

Name the columns in a totals-only table.

Type 6

Indicate an SQL column cannot contain null values

NOT NULL

Define a NULL indicator for SQL columns that are allowed to be NULL.

FB SZ=4

Store additional rows in a previously defined SQL table.

OUTPUT

SQLTABLE=

TYPE=ADD

DICTIONARY=

SCHEMA=

Remove all rows and place new rows in a previously stored SQL table.

OUTPUT

SQLTABLE=

TYPE=REPLACE

DICTIONARY=

SCHEMA=

Delete a previously stored SQL table and all associated data.

OUTPUT

SQLTABLE=

TYPE=DROP

DICTIONARY=

SCHEMA=