Saturday 27 August 2011

AS400 Frequently Asked Interview Questions Answers : II

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

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

What does CHECK opcode do ?
Ans:
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 ?
Ans
:DOUxx, DOWxx, IFxx, and WHxx.

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

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


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

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

What is XFOOT opcode ?
Ans
: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?
Ans:
LO indicator position is seton.

What is the difference between *LIKE and *NAMVAR ?
Ans:
*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 ?
Ans:
The result is same as if you had specified ND.

What is the purpose of OVRDTA and OVRATA keywords ?
Ans:
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 ?
Ans:
OVERLAY

What is RPG ?
Ans:
Report Program Generator.

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

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

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

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

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

How will you display a particular page in subfile ?
Ans:
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 ?
Ans:
Not possible.

What is SFLPAG and SFLSIZ ?
Ans:

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 ?
Ans:
Seton SFLNXTCHG keyword indicator and update the subfile record.

How do you specify the number of records to roll in a subfile ?
Ans:
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 ?
Ans:
Report line, Filler line & Sample line.

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

Source: aired.in

No comments:

Post a Comment