ibm as400 interview questions answers

ibm as400 interview questions answers

Which are the four keywords supported by Program Status Data Structure?
Ans:*STATUS, *PARM, *ROUTINE & *PROGRAM

Which are the String Manipulation Opcodes?
Ans:TESTN, SCAN, CHECK, CHECKR, SUBST & CAT

DB2 is a type of Database?
Ans:It is an Integrated RDBMS.

An access path may be in which sequence?
Ans:It can be in Arrival & Keyed sequence

To change constant field defined on RLU screen which field level keyword should be used?
Ans:DFT (Default)

Space & Skip are which level keywords?
Ans:Field & Record

A Join Logical File has how many Record formats?
Ans:1

A Multiple format Logical File is also known as?
Ans:Union File

How does Union file maintains Record formats?
Ans:1 Record format for each PF

Records can be Read/Update/Deleted with which file?
Ans:Simple Logical File & Physical File.

Which type of object is used in DB2/400?
Ans:*FILE

What is SQL?
Ans:SQL is an interface for programming language.

File level entry for a PF can be?
Ans:UNIQUE & FIFO

What is the command to create FRF?
Ans:CRTPF

Join Logical File displays data from how many files?
2 or more PF’s

A Query can be displayed without saving it?
Ans:True

Which are the Query selection criteria, which can be given in a Query?
Ans:LIST

To add a file to the ‘File Selection’ option of a Query, the function key to be pressed is?
Ans:F9

A query can be run in which mode?
Ans:Batch & Interactive

What is the values SQLCOD when there is an error in fetching the records specified in the select statement?
Ans:-ve value

A file cannot have more than 1 unique key?
Ans:False

DLCOBJ command is mandatory for removing lock on any object?
Ans:False

What is a Journal?
Ans:A Journal is an object used primarily to record changes to data in a PF.

Which are the DB2 tools to protect Integrity of the database?
Ans:Journaling & Commitment Control, Referential Integrity Embedded SQL & Object/Record Locks.