The 4 Types they are Entry, Menu, Information & List Display.
Packed decimal : One digit occupies 1 byte.
Zoned decimal : One digit occupies 2 bytes.
SFLPAG : it is an attribute which specifies the number of records that can be displayed in a screen.
SFLSIZ : it is an attribute which specifies the number of records can be stored in the subfile.
Specifies whether the level identifiers of the record formats in the physical file are checked when the file is opened by the program.
Line counter specification can be used to describe printer file to indicate the length of the form and number of lines per page.
It identifies by H in column 6, provides information about generating and running programs.
This is used to specify rules for the Selection/Omission of records from a Physical File.
CA: – It does not retains the value into the buffer memory.
CF: – It retains the value into the buffer memory.
Overflow indicators
Record Identifying Indicators
Field Indicators
Resulting Indicators
Control Level Indicators
RPG, CL, PF, LF, PRTF & DSPF.
With the help of Command attention key we can pass only the indicator status to program not the data from screen. While command function key passes indicator status as well as a data from screen to program.
To concatenate the two strings by placing a single blank in a resultant.
Prompt depending upon type, shows right hand side date & left hand side the line number.
The FREE operation removes a program from the list of activated programs, frees static storage and ensures program initialization (first cycle processing) the next time program is called. It does not close file or unlock data area.
It allows a record format to be displayed on screen retaining the previous displayed record formats.
We can Insert/Update/Delete records, fetch records, fetch values from records into variables.
Query/400 is a licensed program that uses a query to analyze and select the information contained in the data base files and create a query report.
A query report can be:
* displayed on a workstation (screen)
* printed
* stored in another database file.
All objects are stored on AS/400 in a single level storage.
In this method all objects are referenced by one virtual address which is trlated in to a physical address whether it is an auxiliary storage or main memory.
YYYY-MM-DD for other formats refer to IBM manual or ERIS document.
Journaling & Commitment Control, Referential Integrity Embedded SQL & Object/Record Locks.
DOWxx : If the condition becomes true, then only the group of instructions allowed executing.
DOUxx : Irrespective of condition, it will execute at least one time.
L1 to L9 used to identify certain fields on control fields and then used to condition which operations are to be processed at detail or total calculation or output time.
We must define error message record format (SFLMSG). And a Program Queue. (PGMQ) and Record format is associated to a line number.
CAT – Concatenate two variables or constants into one continuous string.
BCAT – Truncates all trailing blanks in the first character string, one blank is inserted, then the two character strings are concatenated.
TCAT – Truncates all trailing blanks in the first character string, the two character strings are concatenated.
Printed output items placed in an output queue are known as spooled files.
With the help of RTNCSRLOC keyword, here we need to define a field to get row and column. Length of variable should be 5,0 fixed We can specify *FILED for filed *REC for Record on which a key is pressed.
Output queues are queues of jobs waiting to be printed.
* Easy to code and analyze.
* Supports externally described files.
RCVF command used to receive the records either from the data base file or device file.
Extension Specs describes all record address files, arrays and tables.
Use the Start Source Entry Utility command (STRSEU) Option 8 from STRPGMMNU Through Program Development Manager (PDM)