Previous Topic: Summary of Advanced Capabilities for Accessing the DatabaseNext Topic: Minimum Coding Requirements for Using SQL Tables


Minimum Coding Requirements for Using Data Tables

Minimum Input and Output Coding Requirements for Using Data Tables

Task

CA Culprit parameter/keywords

Identify the source of conventional file input to create a table.

INPUT

Define fields from non-IDMS files to CA Culprit.

REC

Define printed output.

OUTPUT

Define an output data table.

 

OUTPUT

TABLE=

TYPE=CREATE

USER=

PW=

CATALOG=

Name the columns in a details-only table.

Type 5 (at least one)

Name the columns in a totals-only table.

Type 6

Retrieve a data table (copy a view).

 

INPUT

TABLE=

TYPE=COPY

USER=

PW=

CATALOG=

Store additional rows in a previously defined data table.

 

OUTPUT

TABLE=

TYPE=ADD

USER=

PW=

CATALOG=

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

 

OUTPUT

TABLE=

TYPE=REPLACE

USER=

PW=

CATALOG=

Delete a previously stored data table and all associated data.

 

OUTPUT

TABLE=

TYPE=DELETE

USER=

PW=

CATALOG=

Modify the table definition of an existing table.

 

OUTPUT

TABLE=

TYPE=GENERATE

USER=

PW=

CATALOG=