Dear Readers, Welcome to AS 400 Interview Questions and Answers have been designed specially to get you acquainted with the nature of questions you may encounter during your Job interview for the subject of AS 400. These AS 400 Questions are very important for campus placement test and job interviews. As per my experience good interviewers hardly plan to ask any particular questions during your Job interview and these model questions are asked in the online technical test and interview of many IT companies.
Using PARM keyword.
CHAR, NUMERIC and LOGICAL
Logical which uses fields from two or more physical files.
This is used to specify rules for the Selection/Omission of records from a Physical File.
Yes. by using CONCAT keyword
Use with Select or Omit, to select/omit records.
File level, Record format level, Field level
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.
SFLCLR : It clears the subfile. SFLINZ : First it clears the subfile and initiliazing the numeric variables with zeros and alphanumeric variables with characters.
A CSRLOC (F1ROW F1COL)
Ans:Using this record level keyword, you can specify cursor location on an output operation to the record format you are defining. The program sends output after setting the cursor location.
If you try to read the locked record, we can get system defined message i. e. , the program will ended abnormally. With the help of File Information Data Structure we can handle record lock situation. Generally it will happen, when the same file of type " U" used in different programs.
The values stored in array don’t vary. In the other hand, we can store the Different values in same variables at various stages.
It identifies by H in column 6, provides informaion about generating and running programs.
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.
In primary file the records will be read and processed from begining to end. This order is not changed. In fully procedural file the records will be read and processed in any order. The logic flow is controlled by the opcodes in RPG program.
The field definitions and descriptions are defined out side of the program in a externally described file. The field definitions and descriptions are defined in side the program in a program described file.
Use this record-level keyword to immediately display a record format, without waiting for the next input or output/input operation.
1.SFLFOLD: To fold the second line of multiple line subfile.
2.SFLDROP: To drop the second line of multiple line subfile.
The values stored in array don’t vary. In the other hand, we can store the different values in same variables at various stages.
Dynamic select occurs whenever the program reads file. But access path occurs before the file is read (but not necessarily). Because access path maintenance performed on the file.
The main difference is : Logical file creates permanent object on the system. OPNQRYF creates temporary access path.
Depends on the factor 1 value it will do two things:
* If the factor1is *LIKE then DEFN opcode defines the new field based on the attributes old field. * If the factor 1 is *NAMVAR then DEFN opcodes defines the field as a data area.