IBM AS400 Interview Questions Answers: Series V

Latest IBM AS400 Interview Questions Answers. 

How many triggers can be associated with a single PF?
Answer :
6 (max)

Can the objects stored in the product library be modified?
Answer :
No.

How many types of objects are there on As/400?
Answer :
80

How is data stored in PF’s?
Answer :
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?
Answer :
DSPFD with parameter TYPE (*TRG)

How can we add & remove trigger to a PF?
Answer :
ADDPFTRG & RMVPFTRG

What is an Output Queue?
Answer :
They are the holding areas that store printed output generated from Batch programs or Interactive applications.

What does print writer do?
Answer :
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?
Answer :
ADDPFTRG & RMVPFTRG

What is an Output Queue?
Answer :
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?
Answer :
No.

Does the SETLL & SETGT retrieve the record?
Answer :
No, they simply position to the record.

What is a table?
Answer :
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?
Answer :
Data from a separate disk file is loaded into a table each time the Program runs.

Give the Table definition?
Answer :
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?
Answer :
Compile Time Table.

What does the members in a Source Physical File contain?
Answer :
Source statements for a program.

The members in LF contain?
Answer :
Access Path.

The members in a PF contain data? (True/False)
Answer :
True

What is the command to view the library list?
Answer :
DSPLIBL

What is the command to create PF?
Answer :
CRTPF

The LF is associated with how many PF’s?
Answer :
At least one PF at a time.
Related Posts

No comments:

 

Aired | Copyright © 2009-2014| All Rights Reserved 2014

Contact Us | About Us