Test 972: ILE RPG Programmer

Use Externally Described Files in Programs (6%)

1. Use externally described database files in a program
2. Use externally described display files in a program
3. Use externally described printer files in a program
4. Use EXTFILE.EXTMBR and OPEN/CLOSE operations in a program

Subfiles (3%)

1. Create and maintain subfiles and programs that use those subfiles (DDS and RPG)
2. Interpret subfile keywords (e.g. SFLCRRRN, SFLDSP, SFLDSPCTL, SFLDROP, SFLPAG, SFLFOLD, SFLRCDNBR, SFLEND,SFLNXTCHG.)

Core RPG (26%)

1. Recognize appropriate use of RPG creation commands (e.g. CRTxxxPGM, CRTxxxMOD, CRTPGM, CRTBNDxxx)
2. Use basic array handling (e.g. *IN, LOOKUP, SORTA, MOVE, MOVEA, indexing)
3. Code and use figurative constants (e.g. *LOVAL, *HIVAL, *ALL, * BLANKS, *ZEROS, *ON, *OFF)
4. Code and use job date and system date
5. Code and use structured operations codes (e.g. DO, DOU, DOW, IF/ELSE/ELSEIF, SELECT/WHEN, EXSR, FOR/ENDFOR)
6. Code and use structured operations codes with expressions (+,-,*,/,**,<,>,=,(),and,or,not)
7. Code and use date data types and arithmetic operations, including date operations in expressions
8. Code and use *INZSR
9. Code and use RPG IV built-in functions
10. Use H-Spec keywords
11. Use RPG IV OpCodes(e.g. Arithmetic, Date, Message, Array, Declarative, File, Branching, String handling, Structured programming, compare, initialization, subroutine, data area)
12. Code and use D-specs, including keywords
13. Use Long Names

Advanced RPG Techniques (26%)

1. Given an example of complex logical expression, determine its results
2. Given an example of nested logic within a sample of RPG code, determine the results of running the code
3. Use data structure arrays
4. Code complex D-specs (e.g. OVERLAY, coding fields without attributes, etc.)
5. Use modern techniques to handle numbered indicators
6. Prototype and use system APIs and C functions
7. Declare and use subprocedures
8. Use externally described data structures
9. Write logic (including I/O operations) without numbered indicators
10. Code and use /free format Calc specifications
11. Translate operation codes not supported in /free form (e.g. MOVE, CALL, etc.) into /free form
12. Use qualified data structures (e.g. LIKEREC, LIKEDS)
13. Use pointer data types
14. Prototype program calls
15. Determine appropriate use of passing parameters by value vs. by reference
16. Enumerate advantages of Prototypes compared with PARM and PLIST
17. Determine appropriate use for prototype keywords such as CONST, VALUE, and OPTIONS (*NOPASS,*OMIT, *VARSIZE)
18. Use EVAL-CORResponding

Performance, Exceptions(Errors), Problems (7%)

1. Debugging RPG Programs
2. Diagnose and eliminate errors for date data types and arithmetic overflow
3. Code and use INFDS, INFSR, SDS and *PSSR
4. Diagnose and eliminate level checks
5. Code and use Monitor and %Error to handle runtime errors

RPG Data Handling (16%)

1. Utilize embedded SQL in an RPG program (including /free form)
2. Differentiate between options for communicating between application processes (e.g. data queues, data areas, parameters, user spaces and user indexes)
3. Code and use I/O directly to/from Data Structures
4. Code and use nested data structures
5. Processing XML data using XML-INTO, XML-SAX
6. Determine multiple ways to use partial keys, including KLISTS, Key Data Structures, and direct specifications of key fields on I/O operations.
7. Demonstrate how to convert character and numeric data fields containing date values into Date data types and vice versa
8. String manipulation with %substring, %scan, %replace
9. Code a trigger program using RPG

ILE (16%)

1. Explain, create and use Binding Directories
2. Differentiate bound procedure calls from dynamic program calls
3. Differentiate "bind by copy" from "bind by reference" and their appropriate uses
4. Determine appropriate use of activation groups, including ILE and non-ILE
5. Create and use Service Programs
6. Create and use multi-module programs
7. Determine the impact and appropriate use of the DFTACTGROUP (Default Activation Group) parameter on the CRTBNDRPG (Create Bound RPG) command
8. Determine causes and ways to avoid Signature Violation errors when using Service Programs
9. Determine appropriate use of the RCLACTGRP (Reclaim Activation Group) command
10. Determine the appropriate use of the scoping parameters for Override and Open commands such as OPNDBF and OPNQRYF
11. Identify differences in exception/error handling for ILE programs (percolation, CEE)