Previous Topic: Using a Data TableNext Topic: Step 2: Displaying Data


Step 1: Loading Data

Select Load Data Function

The Activity Selection screen is displayed. The JOB table has been selected; JOB is displayed in the Table Name field. Select the Load Data ([PF3]) function from the menu on the Activity Selection screen.

The Data Display Screen

The Data Display screen is displayed. This is the screen that was formatted for the table as part of the application you generated.

The column names you defined for the table are listed down the left-hand side of the screen. The cursor is positioned in the response field for the first column.

Each row of the table is loaded individually. Type the column entries for the first row as follows:

   Columns                               Column Entries

   JOB NUMBER                             a261
   DEPARTMENT                             underwriting
   TITLE                                  assistant underwriter
   SALARY                                 13500
   CURRENT STATUS (FILLED OR OPEN)        filled

Load the Row

When you have entered all the column entries for the row, load it into the JOB table by pressing [PF1]. When the row is loaded, the message display field displays the message ROW HAS BEEN ADDED.

                                            CA  PF1 = ADD; PF2 = CHANGE; PF3 = DELETE; ENTER = NEXT; CLEAR = EXIT   JOB   JOB NUMBER   DEPARTMENT   TITLE   SALARY                                 .00   CURRENT STATUS (FILLED OR OPEN)

                        CA  PF1 = ADD; PF2 = CHANGE; PF3 = DELETE; ENTER = NEXT; CLEAR = EXIT   JOB   JOB NUMBER                       a261   DEPARTMENT                       underwriting   TITLE                            assistant underwriter   SALARY                           13500   CURRENT STATUS (FILLED OR OPEN)  filled

Press [Enter] to clear the data from the screen. The column names remain fixed so you can enter the next row. Enter and load all the rows for the JOB table shown below:

JOB NUMBER

DEPARTMENT

TITLE

SALARY

CURRENT STATUS (FILLED OR OPEN)

C417

CLAIMS

CLAIMS ADJUSTER

17000.00

OPEN

O198

OFFICE SERVICES

MAIL CLERK

7000.00

OPEN

B359

BILLING

BILLING CLERK

10000.00

OPEN

Load Rows One at a Time

Remember to load each row individually by selecting the Add function ([PF1]) after typing in the data. Wait for the ROW HAS BEEN ADDED message before pressing [Enter].

Note: You do not have to clear the data from the screen before entering the next row; you can type over the data already loaded. This can save keystrokes when some entries are the same in several rows. Be sure to erase any data from the previous row that does not belong in the current row.

Return

When you have loaded all the rows for the JOB table, press [Clear] to return to the Activity Selection screen.