AS/400 Interview Questions Answers-section 4
What is arrival sequence?
Ans:The records will be accessed the way in which records are added to physical file.
How many specifications are there in RPG/400? What are they?
Ans:There are seven specifications are exits in RPG/400. They are listed below:
* Header Specification ,* File Description specification ,* Extension specification
* Line counter specification ,* Input specification ,* Calculation specification ,* Output specification
When do you use F-spec. continuation line ?
Ans:
* In order to refer the named record format as a subfile record format in the program.
* In order to rename the record format of a database file in a program.
* In order to define a named data structure as a file information data structure.
What are the various types of device files?
Ans:Display files, printer files, discket files, tape files etc. ,
When do you explicitly open files and close files in an RPG program?
Ans:If you specify the letter ' U ' at column 73-74, you need to be open and close files explicitly in a RPG program.
How do you know that records are locked?
Ans:By using a command WRKOBJLCK.
What is the purpose of Indicators in RPG?
Ans:In order to control the logic flow, we can use indicators in RPG.
How do you read data area in an RPG program?
Ans:With the help of 'IN' opcode, we can access the data area record in to the program.
What are the different types of Data Areas?
Ans:
The different types of Data Areas are general data area, local data area, group data area, pip (program initialization parameter data area) data area.
*General Data Area - It can be created by user implicitely or explicitly
It can be referred by any other jobs.
It can be associated with a library.
It can be created, deleted by the user.
* Local Data Area - It can not be referred by any other job.
It is automatically created and deleted by the system.
It is not associated with any library.
*Group Data Area - It is automatically created and deleted by the system
We can access the group data area value through clp.
It is meant for group jobs.
*Pip Data Area - It is meant for pre start jobs.
What are various techniques to pass parameters from one program to another?
Ans:PLIST, CALL, TFRCTL
Which single RPG opcode performs both SETLL and READE?
Ans:CHAIN
What is term CUA , SAA?
Ans:Common User Access
System Application Architecture
Why is AS/400 called Object Oriented Machine?
Ans:Everything on the AS/400 System that can be stored and retrieved is contained in the object.
What is the version of OS/400 that we have?
Ans:V4R2 (Version 4. 0 Release 2. 0)
What is DDM ?
Ans:Distribution Data Management is a function of the OS/400 that allows an application program or user on one system to use database files stored on remote system.
What is an Object?
Ans:An object is any thing that exists in and occupies space in storage and on which operation can be performed.
How are the objects stored on AS/400?
Ans:All objects are stored on AS/400 in a single level storage. In this method all objects are referenced by one virtual address which is translated in to a physical address whether it is an auxiliary storage or main memory.
What is a Library in AS/400?
Ans:A library in AS/400 is an object that serve(acts) as a repository for other objects.
Name few IBM supplied libraries?
Ans:QGPL, QTEMP, QSYS, QUSRTOOL, QCBL, QRPG
What is library list ?
Ans:A list that indicates libraries used for the process and the order in which it has to be searched System identifies it in *LIBL.
How many libraries can be there in library list ?
Ans:Total 40 (15 system and 25 application)
What is Folder?
Ans:A Folder is a named object that is used as a directory for documents and other folders.
Folders can be filed with in another folder.
What is Logical File?
Ans:A Logical file is an Access path to the Physical File.
How can you specify no duplicate key?
Ans:By defining the unique key.
What is the command to know how many LF are related to a PF?
Ans:DSPDBR (Display Database Relationship)
What is the command to know key fields of file?
Ans:DSPFD (F4) *ACCPTH(Access Path).
What is a Join Logical File?
Ans:A join Logical File can be built over the two PF’s, with the PF’s ‘joined’ by a common key value. It is available for read access.
Can a Join Logical File be updated?
Ans:No.
Using DFU, user will be able to ___________ from Physical File?
Ans:Add/Update/Selected or all fields.
What is the difference between normal UPDDTA to PF and updating using DFU program?
Ans:Both are same only difference is DFU allows you to add or change selected fields.
What is Library?
Ans:A library is a system object that serves as a directory to other objects or collection of object
What is Library List?
Ans:A job’s library list defines the path of libraries that the job follows when trying to locate programs, files or other As/400 objects.
Difference between Source Physical File & Physical File?
Ans:Source Physical File contains members who contain source statements & Physical File contains members, which contain data.
What is the object type of PF, LF, Printer file & Display file?
Ans:*File
What are the different methods to access SEU?
Ans: Use the Start Source Entry Utility command (STRSEU) Option 8 from STRPGMMNU Through Program Development Manager (PDM)
Which are the member types which SEU supports?
Ans:RPG, CL, PF, LF, PRTF & DSPF.
In which Specs Arrays, Tables & Constants are defined?
Ans:In I Specs.
What is a Spool File?
Ans:Printed output items placed in an output queue are known as spooled files.
How many Specs are there in RPG & Which are they?
Ans:There are 7 Specs in RPG they are H, F, E, L, I, C & O.
What is the difference between GOTO & EXSR?
Ans:EXSR is a conditional branching while a GOTO is an unconditional branching.
Difference between CA & CF?
Ans:CA: - It does not retains the value into the buffer memory. CF: - It retains the value into the buffer memory.
What does EXFMT does?
Ans:Write & Read.
What does the OVRDBF command do?
Ans:It overrides the PF temporarily for a job.
How does the RUNQRY show the output?
Ans:RUNQRY shows the output always in RRN (Relative Record Number) & not in keyed sequence.
How many printer files maximum can be used in single RPG program?
Ans:8 because of the overflow indicators OA-OG & OV.
When you are defining a flat file in your program in F Specs which format will you specify?
Ans:Flat File: - F (Fixed Length) Other File: - E (Externally Described)
Difference between skip before & space before?
Ans:Skip before leaves the specified no. of lines moving to the next page while Space before leaves the
specified no. of lines on that page.
Which indicator is used for Read?
Ans:EQ (Equal to)
How many types of display are available on As/400 for user interaction?
Ans:4 Types they are Entry, Menu, Information & List Display.
Which is the Primary Editor of As/400? Source Entry Utility (SEU).
What are the basic features of SEU?
Ans:Prompt depending upon type, shows right hand side date & left hand side the line number.
Which are the figurative constants used in RPG?
Ans:*ZERO,*BLANK, *ZEROS, *BLANKS, *HIVAL, *LOVAL, *OFF, *ON & *ALL.
What is the syntax for PLIST?
Ans:*ENTRY PLIST PARM
What are indicators?
Ans:Indicators are inbuilt class of variables for RPG.
What is CAB?
Ans:It compares Factor1 with Factor2 & if condition is true, control is transferred to label designated in the result field. The label
specified must appear as the Factor1 of a TAG operation somewhere in the program.
Which are the Relational Operators in RPG?
Ans:GT, GE, LT, LE & EQ.
In ‘O’ Specs what is the opcode for write?
Ans:EXCPT.
What does LOKUP does in Tables & Arrays?
Ans:The LOKUP opcode searches the Factor1 entry in table or array.
File Access Opcodes?
Ans:READ, SETLL, SETGT, READE, READP, READPE CHAIN, KLIST, KFLD, EXCPT & WRITE.
What is RPG Fixed Logic Cycle?
Ans:A logic the compiler supplies is called RPG Fixed Logic Cycle.
Difference between Interactive & Batch Job?
Ans:Batch job begins, runs & continues to execute instructions without human intervention or control while
Interactive job are user driven.
How can we run a Batch Job?
Ans:SBMJOB Command.
What is arrival sequence?
Ans:The records will be accessed the way in which records are added to physical file.
How many specifications are there in RPG/400? What are they?
Ans:There are seven specifications are exits in RPG/400. They are listed below:
* Header Specification ,* File Description specification ,* Extension specification
* Line counter specification ,* Input specification ,* Calculation specification ,* Output specification
When do you use F-spec. continuation line ?
Ans:
* In order to refer the named record format as a subfile record format in the program.
* In order to rename the record format of a database file in a program.
* In order to define a named data structure as a file information data structure.
What are the various types of device files?
Ans:Display files, printer files, discket files, tape files etc. ,
When do you explicitly open files and close files in an RPG program?
Ans:If you specify the letter ' U ' at column 73-74, you need to be open and close files explicitly in a RPG program.
How do you know that records are locked?
Ans:By using a command WRKOBJLCK.
What is the purpose of Indicators in RPG?
Ans:In order to control the logic flow, we can use indicators in RPG.
How do you read data area in an RPG program?
Ans:With the help of 'IN' opcode, we can access the data area record in to the program.
What are the different types of Data Areas?
Ans:
The different types of Data Areas are general data area, local data area, group data area, pip (program initialization parameter data area) data area.
*General Data Area - It can be created by user implicitely or explicitly
It can be referred by any other jobs.
It can be associated with a library.
It can be created, deleted by the user.
* Local Data Area - It can not be referred by any other job.
It is automatically created and deleted by the system.
It is not associated with any library.
*Group Data Area - It is automatically created and deleted by the system
We can access the group data area value through clp.
It is meant for group jobs.
*Pip Data Area - It is meant for pre start jobs.
What are various techniques to pass parameters from one program to another?
Ans:PLIST, CALL, TFRCTL
Which single RPG opcode performs both SETLL and READE?
Ans:CHAIN
What is term CUA , SAA?
Ans:Common User Access
System Application Architecture
Why is AS/400 called Object Oriented Machine?
Ans:Everything on the AS/400 System that can be stored and retrieved is contained in the object.
What is the version of OS/400 that we have?
Ans:V4R2 (Version 4. 0 Release 2. 0)
What is DDM ?
Ans:Distribution Data Management is a function of the OS/400 that allows an application program or user on one system to use database files stored on remote system.
What is an Object?
Ans:An object is any thing that exists in and occupies space in storage and on which operation can be performed.
How are the objects stored on AS/400?
Ans:All objects are stored on AS/400 in a single level storage. In this method all objects are referenced by one virtual address which is translated in to a physical address whether it is an auxiliary storage or main memory.
What is a Library in AS/400?
Ans:A library in AS/400 is an object that serve(acts) as a repository for other objects.
Name few IBM supplied libraries?
Ans:QGPL, QTEMP, QSYS, QUSRTOOL, QCBL, QRPG
What is library list ?
Ans:A list that indicates libraries used for the process and the order in which it has to be searched System identifies it in *LIBL.
How many libraries can be there in library list ?
Ans:Total 40 (15 system and 25 application)
What is Folder?
Ans:A Folder is a named object that is used as a directory for documents and other folders.
Folders can be filed with in another folder.
What is Logical File?
Ans:A Logical file is an Access path to the Physical File.
How can you specify no duplicate key?
Ans:By defining the unique key.
What is the command to know how many LF are related to a PF?
Ans:DSPDBR (Display Database Relationship)
What is the command to know key fields of file?
Ans:DSPFD (F4) *ACCPTH(Access Path).
What is a Join Logical File?
Ans:A join Logical File can be built over the two PF’s, with the PF’s ‘joined’ by a common key value. It is available for read access.
Can a Join Logical File be updated?
Ans:No.
Using DFU, user will be able to ___________ from Physical File?
Ans:Add/Update/Selected or all fields.
What is the difference between normal UPDDTA to PF and updating using DFU program?
Ans:Both are same only difference is DFU allows you to add or change selected fields.
What is Library?
Ans:A library is a system object that serves as a directory to other objects or collection of object
What is Library List?
Ans:A job’s library list defines the path of libraries that the job follows when trying to locate programs, files or other As/400 objects.
Difference between Source Physical File & Physical File?
Ans:Source Physical File contains members who contain source statements & Physical File contains members, which contain data.
What is the object type of PF, LF, Printer file & Display file?
Ans:*File
What are the different methods to access SEU?
Ans: Use the Start Source Entry Utility command (STRSEU) Option 8 from STRPGMMNU Through Program Development Manager (PDM)
Which are the member types which SEU supports?
Ans:RPG, CL, PF, LF, PRTF & DSPF.
In which Specs Arrays, Tables & Constants are defined?
Ans:In I Specs.
What is a Spool File?
Ans:Printed output items placed in an output queue are known as spooled files.
How many Specs are there in RPG & Which are they?
Ans:There are 7 Specs in RPG they are H, F, E, L, I, C & O.
What is the difference between GOTO & EXSR?
Ans:EXSR is a conditional branching while a GOTO is an unconditional branching.
Difference between CA & CF?
Ans:CA: - It does not retains the value into the buffer memory. CF: - It retains the value into the buffer memory.
What does EXFMT does?
Ans:Write & Read.
What does the OVRDBF command do?
Ans:It overrides the PF temporarily for a job.
How does the RUNQRY show the output?
Ans:RUNQRY shows the output always in RRN (Relative Record Number) & not in keyed sequence.
How many printer files maximum can be used in single RPG program?
Ans:8 because of the overflow indicators OA-OG & OV.
When you are defining a flat file in your program in F Specs which format will you specify?
Ans:Flat File: - F (Fixed Length) Other File: - E (Externally Described)
Difference between skip before & space before?
Ans:Skip before leaves the specified no. of lines moving to the next page while Space before leaves the
specified no. of lines on that page.
Which indicator is used for Read?
Ans:EQ (Equal to)
How many types of display are available on As/400 for user interaction?
Ans:4 Types they are Entry, Menu, Information & List Display.
Which is the Primary Editor of As/400? Source Entry Utility (SEU).
What are the basic features of SEU?
Ans:Prompt depending upon type, shows right hand side date & left hand side the line number.
Which are the figurative constants used in RPG?
Ans:*ZERO,*BLANK, *ZEROS, *BLANKS, *HIVAL, *LOVAL, *OFF, *ON & *ALL.
What is the syntax for PLIST?
Ans:*ENTRY PLIST PARM
What are indicators?
Ans:Indicators are inbuilt class of variables for RPG.
What is CAB?
Ans:It compares Factor1 with Factor2 & if condition is true, control is transferred to label designated in the result field. The label
specified must appear as the Factor1 of a TAG operation somewhere in the program.
Which are the Relational Operators in RPG?
Ans:GT, GE, LT, LE & EQ.
In ‘O’ Specs what is the opcode for write?
Ans:EXCPT.
What does LOKUP does in Tables & Arrays?
Ans:The LOKUP opcode searches the Factor1 entry in table or array.
File Access Opcodes?
Ans:READ, SETLL, SETGT, READE, READP, READPE CHAIN, KLIST, KFLD, EXCPT & WRITE.
What is RPG Fixed Logic Cycle?
Ans:A logic the compiler supplies is called RPG Fixed Logic Cycle.
Difference between Interactive & Batch Job?
Ans:Batch job begins, runs & continues to execute instructions without human intervention or control while
Interactive job are user driven.
How can we run a Batch Job?
Ans:SBMJOB Command.
