AS400 Technical Interview Question and Answer – AS400 Database

iSeries

Jul 26
55

Twenty years ago these are the kind of things you had to know to work on the old AS400 systems. I found these on an old dusty corner of my homeserver. Enjoy the trip down memory lane or to use old RPG lingo AS400NERD CABEQ ‘1’  START

DATABASE FILES

What are the different definition levels in Data Description specifications ?
File level, Record level, Field level, Join level, Keyfield level, Select/Omit level.

What is difference between Source Physical File and Physical File ?
A Source Physical File contains the source for the various objectscreated. This file has a specific structure. A Physical File contains data, and the record format can be different for different physical files.

What is the difference between Physical and Logical files ?
Physical file contains data, where as Logical file serves as a access path to database.

What is an access path ?
The order in which the database fields are organized for processing in the program.

What are all the different types of access paths ?
Arrival sequence access path, Keyed sequence access path.

How many record formats can you have in a Physical file and in a Logical file ?
Physical file can contain only one record format, Logical file can contain more than one record format.

What is a field reference file ?
A field reference file is a physical file which contains no data, contains field description. this is used as a reference file by other physical files.

What is the default value for the number of increments for the physicalfile ?
Three.

When is the DFT keyword in PF used for?
To specify the default value it a field.

What is Multi-format logical file ?
Logical which uses fields from two or more physical files.

What is dynamic select ?
Selection and omission of LF records performed during processing, instead of access path is maintained. This can be used when key access path does not exist.

What is the Select and Omit criteria in logical file ?
This is used to specify rules for the Selection/Omission of records from a Physical File.

Can fields be concatenated at the logical file level ?
Yes, by using CONCAT keyword.

When would the ALL keyword be used ?
Use with Select or Omit, to select/omit records.

What is a Join Logical File, Can it be used for Update ?
Logical file that combines more than one physical file.Update is not possible through JLF.

How many files can be joined at a time, What is the max. no. of files ?
At a time you can join two files. The max. no. of files is 32.Only one primary file and the remaining are secondary files, The primary file and at least one secondary file must be physical files.

Is it possible to join the same file to itself ?
Yes.

What is FCFO, FIFO, LIFO in Database environment ?

These are file level keywords which are used to access the records in the order
FCFO : First Changed First Out
FIFO : First In First Out
LIFO : Last In Fist Out

If a file layout is changed, how do you generate new PF and retain data?
Copy the file and change the structure of Physical file, later copy old file with drop option.

What is the overhead on logical file ? How can it be improved ?
Maintaining access path and storage space. We can improve the performance by using *DELAYED, *REBUILD keywords to enhance the speed.

How can the sign of a numeric be ignored when sequencing a logical file ?
By specifying the record level keyword UNSIGNED.

If a field references a field that has an EDTCDE or an EDTWRD keyword specified, can the EDTCDE or EDTWRD from the referenced field ignored ?
Yes, by using DLTEDT keyword.

What does the keyword UNIQUE mean ?
Records with duplicate key values are not allowed.

State three different methods of maintaining access paths ?
Immediate, Rebuild & Delay.

BACK – /interview-question-and-answer-miscellanous-things-you-should-know

Follow

About the Author

IBM i Software Developer, Digital Dad, AS400 Anarchist, RPG Modernizer, Alpha Nerd and Passionate Eater of Cheese and Biscuits. Nick Litten Dot Com is a mixture of blog posts that can be sometimes serious, frequently playful and probably down-right pointless all in the space of a day. Enjoy your stay, feel free to comment and in the words of the most interesting man in the world: Stay thirsty my friend.