AS/400 Interview Questions Answers-section 2-b
How many triggers can be associated with a single PF?
Ans:6 (max)
Can the objects stored in the product library be modified?
Ans:No.
How many types of objects are there on As/400?
Ans:80
How is data stored in PF’s?
Ans:In fixed length records.
Give an example of DEFN opcode?
Ans:*LIKE DEFN ENAME $ENAME (Now the $ENAME has all the attributes same like ENAME)
What is DBMS?
Ans:A DBMS is a software system that controls the creation, organization & modification of a database & access to the date stored within it.
How can we know the triggers associated with the PF?
Ans:DSPFD with parameter TYPE (*TRG)
How can we add & remove trigger to a PF?
Ans:ADDPFTRG & RMVPFTRG
What is an Output Queue?
Ans:They are the holding areas that store printed output generated from Batch programs or Interactive applications.
What does print writer do?
Ans:It is a system job that selects files from the output queue & prints Them on a printer. It provides the interface between
output queue’s Spooled files & the printer.
What are the 2 types of lines on O Specs?
Ans:Record Identification Line & Field Identification Line.
How can we add & remove trigger to a PF?
Ans:ADDPFTRG & RMVPFTRG
What is an Output Queue?
Ans:They are the holding areas that store printed output generated from Batch programs or Interactive applications.
What does print writer do?
Ans:It is a system job that selects files from the output queue & prints Them on a printer. It provides the interface between
output queue’s Spooled files & the printer.
Can a Subroutine contain another Subroutine?
Ans:No.
Does the SETLL & SETGT retrieve the record?
Ans:No, they simply position to the record.
What is a table?
Ans:A table is collection of data elements in one column, data elements Must be of same type and same length.
What is a Compile Time Table?
Ans:We can hard code data within the program is said to be Compile Time Table.
What is a Run Time Table?
Ans:Data from a separate disk file is loaded into a table each time the Program runs.
Give the Table definition?
Ans:TABMT 1 12 2 A Where 1 = Number of entries per record 12 = Total number of entries 2 = Length of each entry A = Ascending
Sequene
If the data is likely to change over a period of time & Moreover data is large than which type of table is preferred?
Ans:Compile Time Table.
What does the members in a Source Physical File contain?
Ans:Source statements for a program.
The members in LF contain?
Ans:Access Path.
The members in a PF contain data? (True/False)
Ans:True
What is the command to view the library list?
Ans:DSPLIBL
What is the command to create PF?
Ans:CRTPF
The LF is associated with how many PF’s?
Ans:At least one PF at a time.
Difference between CALL & SBMJOB?
Ans:CALL performs interactively job while SBMJOB performs batch job.
Maximum number of Records in Display File?
Ans:1024
What does VLDCMDKEY means?
Ans:Valid Command Key.
What is Subroutine in RPG?
Ans:A subroutine is a group of statements in a program that can be processed several times in that program.
Do we have to Execute the *INZSR compulsory?
Ans:No, it is a system-defined subroutine it is executed automatically.
What is the use of *PSSR in the program?
Ans:Whenever there is any type error in the program the control straight away passes onto this subroutine.
Types of Tables in RPG?
Ans:There are 2 types of tables in RPG they are: - Compile Time Tables Pre-Runtime Tables
What is the error if we don’t get login screen?
Ans:There is some problem with subsystem.
How to run other job when one job is active?
Ans:Change the priority or rename the job.
Use of Data Structures?
Ans:
· Dividing a field into sub fields.
· Changing the format of a field.
· Grouping non-contiguous data in a contiguous format.
· Defining an area of storage in more than 1 format.
Types of Data Structures?
Ans:
a. File Information Data Structure.
b. Program Status Data Structure.
c. User Defined Data Structure.
d. Multiple Occurrence Data Structure.
e. Date Area Data Structure.
What is Subfile?
Ans:A Subfile is a temporary area in memory which records may written to & read from a display file device.
Which is the subsystem that is always on till the main power switch is off?
Ans:QCTL
What is the command to shutdown the As/400 Server?
Ans:PWRDWNSYS & Parameter *IMMED.
How can we know the CPU utilization of the server?
Ans:WRKACTJOB (Work with active job) WRKSYSSTS (Work with system status)
Which are the libraries (system) always present in the library list?
Ans:QTEMP & QGPL
Which users are allowed to manipulate system libraries?
Ans:QSECOFR & QSYSOPR
What is a Join Logical File?
Ans:A Join Logical File combines information from two or more physical files into one record format. Join Logical Files have
always one record format.
Types of Object Locks & what they do?
Ans:There are mainly 3 types of locks they are as follow: - *EXCL : Only the routing step holding the lock can use the
object *EXCLRD : Routing step can read/update the file other jobs can only read. *SHRUPD : All jobs can read/update the object.
How do you place or remove locks on the objects?
Ans:*AACOBJ & *DLCOBJ
Some of the object types on which locks can be allocated?
Ans:Data Area, Data Queue, File, Library, Message Queue, Menu &Program.
What is the opcode to release all the locks on a particular PF?
Ans:UNLCK
What is a trigger?
Ans:A trigger is an action that automatically occurs whenever a change Is made to a physical file.
How many triggers can be associated with a single PF?
Ans:6 (max)
Can the objects stored in the product library be modified?
Ans:No.
How many types of objects are there on As/400?
Ans:80
How is data stored in PF’s?
Ans:In fixed length records.
Give an example of DEFN opcode?
Ans:*LIKE DEFN ENAME $ENAME (Now the $ENAME has all the attributes same like ENAME)
What is DBMS?
Ans:A DBMS is a software system that controls the creation, organization & modification of a database & access to the date stored within it.
How can we know the triggers associated with the PF?
Ans:DSPFD with parameter TYPE (*TRG)
How can we add & remove trigger to a PF?
Ans:ADDPFTRG & RMVPFTRG
What is an Output Queue?
Ans:They are the holding areas that store printed output generated from Batch programs or Interactive applications.
What does print writer do?
Ans:It is a system job that selects files from the output queue & prints Them on a printer. It provides the interface between
output queue’s Spooled files & the printer.
What are the 2 types of lines on O Specs?
Ans:Record Identification Line & Field Identification Line.
How can we add & remove trigger to a PF?
Ans:ADDPFTRG & RMVPFTRG
What is an Output Queue?
Ans:They are the holding areas that store printed output generated from Batch programs or Interactive applications.
What does print writer do?
Ans:It is a system job that selects files from the output queue & prints Them on a printer. It provides the interface between
output queue’s Spooled files & the printer.
Can a Subroutine contain another Subroutine?
Ans:No.
Does the SETLL & SETGT retrieve the record?
Ans:No, they simply position to the record.
What is a table?
Ans:A table is collection of data elements in one column, data elements Must be of same type and same length.
What is a Compile Time Table?
Ans:We can hard code data within the program is said to be Compile Time Table.
What is a Run Time Table?
Ans:Data from a separate disk file is loaded into a table each time the Program runs.
Give the Table definition?
Ans:TABMT 1 12 2 A Where 1 = Number of entries per record 12 = Total number of entries 2 = Length of each entry A = Ascending
Sequene
If the data is likely to change over a period of time & Moreover data is large than which type of table is preferred?
Ans:Compile Time Table.
What does the members in a Source Physical File contain?
Ans:Source statements for a program.
The members in LF contain?
Ans:Access Path.
The members in a PF contain data? (True/False)
Ans:True
What is the command to view the library list?
Ans:DSPLIBL
What is the command to create PF?
Ans:CRTPF
The LF is associated with how many PF’s?
Ans:At least one PF at a time.
Difference between CALL & SBMJOB?
Ans:CALL performs interactively job while SBMJOB performs batch job.
Maximum number of Records in Display File?
Ans:1024
What does VLDCMDKEY means?
Ans:Valid Command Key.
What is Subroutine in RPG?
Ans:A subroutine is a group of statements in a program that can be processed several times in that program.
Do we have to Execute the *INZSR compulsory?
Ans:No, it is a system-defined subroutine it is executed automatically.
What is the use of *PSSR in the program?
Ans:Whenever there is any type error in the program the control straight away passes onto this subroutine.
Types of Tables in RPG?
Ans:There are 2 types of tables in RPG they are: - Compile Time Tables Pre-Runtime Tables
What is the error if we don’t get login screen?
Ans:There is some problem with subsystem.
How to run other job when one job is active?
Ans:Change the priority or rename the job.
Use of Data Structures?
Ans:
· Dividing a field into sub fields.
· Changing the format of a field.
· Grouping non-contiguous data in a contiguous format.
· Defining an area of storage in more than 1 format.
Types of Data Structures?
Ans:
a. File Information Data Structure.
b. Program Status Data Structure.
c. User Defined Data Structure.
d. Multiple Occurrence Data Structure.
e. Date Area Data Structure.
What is Subfile?
Ans:A Subfile is a temporary area in memory which records may written to & read from a display file device.
Which is the subsystem that is always on till the main power switch is off?
Ans:QCTL
What is the command to shutdown the As/400 Server?
Ans:PWRDWNSYS & Parameter *IMMED.
How can we know the CPU utilization of the server?
Ans:WRKACTJOB (Work with active job) WRKSYSSTS (Work with system status)
Which are the libraries (system) always present in the library list?
Ans:QTEMP & QGPL
Which users are allowed to manipulate system libraries?
Ans:QSECOFR & QSYSOPR
What is a Join Logical File?
Ans:A Join Logical File combines information from two or more physical files into one record format. Join Logical Files have
always one record format.
Types of Object Locks & what they do?
Ans:There are mainly 3 types of locks they are as follow: - *EXCL : Only the routing step holding the lock can use the
object *EXCLRD : Routing step can read/update the file other jobs can only read. *SHRUPD : All jobs can read/update the object.
How do you place or remove locks on the objects?
Ans:*AACOBJ & *DLCOBJ
Some of the object types on which locks can be allocated?
Ans:Data Area, Data Queue, File, Library, Message Queue, Menu &Program.
What is the opcode to release all the locks on a particular PF?
Ans:UNLCK
What is a trigger?
Ans:A trigger is an action that automatically occurs whenever a change Is made to a physical file.
