Maricopa Community Colleges  CIS222   19926-19995 
Official Course Description:   MCCCD Approval:  05/26/92  
CIS222      19926-19995 L+L 3 Credit(s) 4 Period(s)
AS/400 Utilities and CL Programming
Use of system utility programs and Control Language (CL) programming on the IBM AS/400 midrange computer. Utilities to build and manipulate files and programs; writing CL programs to do useful system tasks. Prerequisites: CIS121AE or permission of instructor.
 
 Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS222   19926-19995 AS/400 Utilities and CL Programming
1. Use the Source Entry utility program to develop coding for Data Definition Specifications and CL programs. (I)
2. Employ the Data File utility program to add and change records in a data file. (II)
3. Utilize the Query/400 utility program to create simple and complex reports from a data file. (III)
4. Develop useful data entry screens with the help of the Screen Design Aid utility program. (IV)
5. Design data files, using Data Definition Specifications. (V)
6. Plan and write practical control Language programs to accomplish useful AS/400 system tasks. (VI)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS222   19926-19995 AS/400 Utilities and CL Programming
    I. Source Entry utility
        A. Prompts
        B. Line commands
      II. Data File utility
          A. Basic data entry
          B. Updating entries
        III. Query/400 utility
            A. Basic query procedures
            B. Sorting
            C. Specifying selection criteria
            D. Improving reports with text
            E. Derived fields
          IV. Screen Design Aid
              A. Basic screen design
              B. Implementing function keys and options
              C. Building menus
            V. Data definition specification
                A. File design concepts
                B. Defining records
                C. Defining fields
                D. Applying tests to fields
              VI. CL programming
                  A. Basic program entry
                  B. Variables
                  C. Controlling execution
                  D. Data areas
                  E. Exception handling
                  F. Using database files in CL progams
                  G. Calling other programs from a CL program
              Go to Description    Go to top of Competencies    Go to top of Outline