Latest Questions
Post Top Ad
Your Ad Spot
Monday, June 17, 2019

25 Top AS/400 Interview Questions and Answers {Updated}

AS/400 Interview Questions and Answers for experienced PDF, Read commonly asked AS/400 Job Interview Questions with Answers PDF for Freshers.


Read AS/400 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 a Multi-format logical file?
Logical which uses fields from two or more physical files.

What is the Select and Omit criteria in the 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 the 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 initializing 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 the system-defined message i. e. , the program will be ended abnormally. With the help of File Information Data Structure, we can handle the record lock situation. Generally, it will happen, when the same file of type ” U” used in different programs.

What is the difference between array and a multiple occurrence data structure?
The values stored in the array don’t vary. In the other hand, we can store the Different values in the same variables at various stages.

What is the use of Header Specification in RPG/400?
It identifies by H in column 6, provides information about generating and running programs.

What are Control level indicators?
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.

What is the difference between a fully procedural file and primary file?
In the primary file, the records will be read and processed from beginning 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 the RPG program.

What is the difference between an externally described file and program described file?
The field definitions and descriptions are defined outside of the program in an externally described file. The field definitions and descriptions are defined inside the program in a program described file.

What is the purpose of FRCDTA (Force Data) keyword?
Use this record-level keyword to immediately display a record format, without waiting for the next input or output/input operation.

What is the purpose of SFLFOLD and SFLDROP keywords?
  • SFLFOLD: To fold the second line of multiple line subfile.
  • SFLDROP: To drop the second line of multiple line subfile.

What is the difference between array and a multiple occurrence data structure?
The values stored in the array don’t vary. In the other hand, we can store the different values in the same variables at various stages.

What is the difference between the access path and Dynamic select?
Dynamic select occurs whenever the program reads the file. But access path occurs before the file is read (but not necessarily). Because access path maintenance performed on the file.

Why would you prefer OPNQRYF than logical file?
The main difference is: Logical file creates a permanent object on the system. OPNQRYF creates temporary access path.

What is the purpose of declarative statement DEFN?
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 factor 1 is *NAMVAR then DEFN opcodes define the field as a data area.

Post Top Ad

Your Ad Spot

Pages