TOP AS400 Interview Questions and Answers
How do you pass parameters in CL?
Using PARM keyword.
What are the valid user defined data area types?
CHAR, NUMERIC and LOGICAL
What is Multi-format logical file?
Logical which uses fields from two or more physical files.
What is the Select and Omit criteria in logical file?
This is used to specify rules for the Selection/Omission of records from a Physical File.
Can fields be concatenated IN a logical file level?
Yes. by using CONCAT keyword
When would the ALL keyword be used?
Use with Select or Omit, to select/omit records.
What are the different types of keywords in display files?
File level, Record format level, Field level
What is difference between CAT, TCAT, BCAT?
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.
What is the difference between SFLCLR and SFLINZ?
SFLCLR : It clears the subfile.
SFLINZ : First it clears the subfile and initiliazing the numeric variables with zeros and alphanumeric variables with characters.
What is the purpose of the following? A CSRLOC (F1ROW F1COL)
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.
How can you detect and handle a record lock situation?
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.