Previous Topic: Creating TablesNext Topic: Demonstration (1): Creating a Table from a Sequential File

Building and Using Data Tables › Creating Tables › What You Can Do

What You Can Do

You can:

How to Do It

To create a table:

  1. Define the incoming data using input definition parameters (shown in the table below).
  2. Define the table using the OUTPUT parameter and the keywords listed in the table below.
  3. Define the columns of the table using type 5 or type 6 parameters.
  4. Specify special options, as needed, using the options listed in the table below.

You can find complete descriptions of the parameters and keywords in the CA Culprit for CA IDMS Reference Guide.

Required Parameters and Keywords for Creating a Table

If the data source is...

the required parameters and keywords are...

A conventional file (sequential, ISAM, and VSAM)

An INPUT parameter, including the file type (PS, IS, CARD, or VS)

REC parameters (at least one)

An OUTPUT parameter with:

TABLE=

TYPE=CREATE

USER=

PW=

CATALOG=

Type 5 parameters (at least one)

Type 6 parameters to create a totals-only table

A CA IDMS/DB database

A DATABASE PARAMETER with DICTNAME=

An INPUT DB SS= parameter

A PATH parameter

An OUTPUT parameter with:

TABLE=

TYPE=CREATE

USER=

PW=

CATALOG=

Type 5 parameters (at least one)

Type 6 parameters to create a totals-only table

An existing table

An INPUT parameter with:

TABLE=

TYPE=COPY

USER=

PW=

CATALOG=

An OUTPUT parameter with:

TABLE=

TYPE=CREATE

USER=

PW=

CATALOG=

Type 5 parameters (at least one)

Type 6 parameters to generate a totals-only table

Options Available when Creating a Table

The option ...

used on this parameter ...

specifies ...

IX=

type 5 or type 6

table row storage indexed in ascending (A) or descending (D) order

0151*001 CUST-NUM IX=A

COLUMN=

type 5 or type 6

absolute field placement for tables extending beyond column 9999

0151 NAME COL=13001

T/D

OUTPUT

a totals-only (T) or a details-only (D) report

COMMENT=' '

OUTPUT

ASF comment field update

AREA=

OUTPUT

ASF area name field update

ONLINE=YES/NO

OUTPUT

Whether to create dialogs and maps for table viewing

DISPLAY=YES/NO

OUTPUT

The ability to retrieve data from the table

LOAD=YES/NO

OUTPUT

The ability to store data on the table

CHANGE=YES/NO

OUTPUT

The ability to update data from the table

ERASE=YES/NO

OUTPUT

The ability to erase rows of data

For more information about ASF, see the CA IDMS ASF User Guide.