Saturday 27 August 2011

IBM AS400 Interview Questions Answers: Series V

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.

Source: aired.in

No comments:

Post a Comment