Previous Topic: What You Can DoNext Topic: Modifying Data Tables


Demonstration

Objective

This report retrieves and prints a listing of the part-time employees from the PART-TIME table, which was created earlier in this chapter.

Parameters

INPUT TABLE=PART-TIME
TYPE=COPY USER=DOC1
PW=DOC1
*CATALOG=ASFDICT

INPUT identifies the INPUT parameter, which includes the COPY instruction.

TABLE=PART-TIME specifies the table used for input. TABLE= must be the first keyword on the INPUT parameter.

TYPE=COPY specifies copying the PART-TIME table. TYPE= must be the second keyword on the INPUT parameter.

USER=DOC1 PW=DOC1 identifies the user and password for signing on to the catalog.

CATALOG=ASFDICT identifies the catalog that contains the table definition.

01OUTPUT 60

OUTPUT 60 specifies printed output with 60 character lines.

Complete Code

 col. 2
 ▼
 INPUT TABLE=PART-TIME TYPE=COPY USER=DOC1 PW=DOC1
*CATALOG=ASFDICT
 01OUTPUT 60
 013 PART-TIME EMPLOYEE LISTING
 0151*010 ID                   HH 'EMPLOYEE ID'
 0151*020 NAME                 HH 'EMPLOYEE NAME'

Result

REPORT NO. 01    PART-TIME EMPLOYEE LIST mm/dd/yy PAGE     1                EMPLOYEE ID     EMPLOYEE NAME                     476      BETSY     ZEDI                      51      CYNTHIA   JOHNSON                      49      DOUGLAS   KAHALLY                     457      HARRY     ARM