AS400 Frequently Asked Interview Questions Answers : II

IBM AS400 Frequently Asked Interview Questions Answers.

What are the different Opcodes available in RPG for Database access ?
Answer : READ, CHAIN, WRITE, UPDAT, DELET, SETLL, SETGT, READE, READP, REDPE, OPEN, CLOSE, FORCE, NEXT, UNLCK.

How can database records be read without lock ?
Answer : Put 'N' in position 53 of C specs.

What does CHECK opcode do ?
Answer : The check operation verifies that each character in the base string (factor 2) is among the ` character indicated in the comparator string(factor 1).

In conjunction with which statements can ORxx and ANDxx conditions be used ?
Answer : DOUxx, DOWxx, IFxx, and WHxx.

What does opcode POST do ?
Answer : Puts information in INFDS.

Can you have multiple key lists for a single file ?
Answer : Yes.

What are the different types of arrays available in RPG ?
Answer : Pre-execution time array.
Compile time array.
Execution time array.

Can we define Multi-dimensional arrays in RPG ?
Answer :  No.

What is XFOOT opcode ?
Answer : Adds all the elements in a numeric array, and places the sum in the result field.

During input operation which indicator position is seton if there is a record lock?
Answer : LO indicator position is seton.

What is the difference between *LIKE and *NAMVAR ?
Answer : *LIKE defines the variables as in database.
*NAMVAR is used to define variables as data area.

What would be the effect on the field where reverse image, underline and highlight display attributes are active ?
Answer : The result is same as if you had specified ND.

What is the purpose of OVRDTA and OVRATA keywords ?
Answer : OVRDTA keyword (field or record level) can be used to override the existing data contents of a field or record already on the display.
OVRATA keyword (field or record level) can be used to override the existing display attributes of a field or record already on the display.

What keyword must be used with PROTECT keyword ?
Answer : OVERLAY

What is RPG ?
Answer : Report Program Generator.

Where will control be passed after the execution of the *PSSR subroutine if the factor2 of the ENDSR is blank ?
Answer : Control will return to the next sequential instruction.

What is the maximum number of subfiles that can specified in a display file ?
Answer : 512

The maximum number of subfiles that can defined in a RPG program for one display file is ___ .
Answer : 24

The maximum number of subfiles that can be active for a single file is ____ .
Answer : 12

What are the different opcodes used for file operation on a subfile in a RPG pgm?
Answer : READ, READC, CHAIN,UPDAT and WRITE

How will you display a particular page in subfile ?
Answer : Move a valid relative record number(RRN) in the field specified using SFLRCDNBR keyword in DDS.

Can a single screen format occupy a screen area above and below a subfile format ?
Answer : Not possible.

What is SFLPAG and SFLSIZ ?
Answer :
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.

How to pick up the changed records every time in a subfile after the first change made ?
Answer : Seton SFLNXTCHG keyword indicator and update the subfile record.

How do you specify the number of records to roll in a subfile ?
Answer : Use SFLROLVAL keyword in DDS along with the number, which specifies the number of records to scroll at a time.

What are the three line types in RLU ?
Answer : Report line, Filler line & Sample line.

What is the function of RLU ?
Answer : To design & prototype a report.

Related Posts