Creating and Using Stored Tables › Defining a Stored Table › Step 1: Name the Table

Step 1: Name the Table

When you first sign on to ASF, the Activity Selection (ASEL) screen is displayed. This screen has three sections:

Name the Table

The cursor is positioned at the first entry in the directory, or at the Table Name field if the directory is empty. Position the cursor in the Table Name field. Type job in the Table Name field, as shown below:

                                            CA
  ASEL   CA - Automatic System Facility           ** Activity Selection **
  DC560004 SELECT A TABLE

  User Name: SNELL

  _ PF1 - Help                  _ PF5 - Select Data     _ PF13  - Query
  _ PF2 - Define Table          _ PF7 - Page Backward   _ PF14  - Signon
  _ PF3 - Load Data             _ PF8 - Page Forward    _ PA1   - Prior Level
  _ PF4 - Display/Change Data   _ PF9 - Passkey         _ CLEAR - Leave ASF


  Table Name.: job
  Table Owner: SNELL
                                                                 Page:  1  of  1

Select Define Table Function

After you name the table, select the Define Table function from the activity selection menu in one of the following ways:

• Press [PF2].
• Type 2 in the simulated PF-key field and press [Enter].
• Enter any character (except a blank or underscore character) in the response field for the Define Table function.
• Type tdef in the screen name field.

Note: In subsequent steps, the PF-key associated with a function is shown in parentheses. You can select any function by pressing the PF-key shown, entering the PF-key number in the simulated PF-key field, typing a character in the response field for the listed function, or entering the appropriate screen name in the screen name field. In any sample screens where the next function is indicated, the function is selected from the menu by typing x in the response field, or the appropriate screen name is entered in the screen name field.

Table Definition Screen

The Table Definition (TDEF) screen is now displayed. Notice that the table name JOB is in the Table Name field. Your user ID is in the Table Owner field.

The View/Stored field below the Table Owner field contains the default value STORED.

The Defn Number (definition number) field is blank. The Status field below the Defn Number field contains the value NEW, indicating that this is a new table that has not yet been defined.

Select Define Columns Function

Now you are ready to define the columns of the JOB table. Select the Define Columns function ([PF2]) from the activity selection menu, as illustrated below.

                                            CA
  TDEF   CA - Automatic System Facility            ** Table Definition **
  DC560005 MODIFY AND/OR SELECT NEXT ACTIVITY

         _ PF1 - Help                     _ PF4 - Extended Table Definition
         x1PF2 - Define Columns           _ PF5 - Delete Table Definition
         _ PF3 - Generate                 _ PF6 - Message Screen

  Table Name.: JOB
  Table Owner: SNELL                                 Defn Number:
  View/Stored: STORED2                               Status.....: NEW3
  Comments...:

1. Select the DEFINE COLUMNS function.
2. The JOB table is being defined as a stored table.
3. The table status is NEW since the JOB table is not yet defined.