AS400 Technical Interview Questions
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.
