Which are the four keywords supported by Program standing knowledge Structure?
*STATUS, *PARM, *ROUTINE & *PROGRAM
Which are the String Manipulation Opcodes?
TESTN, SCAN, CHECK, CHECKR, SUBST & CAT
DB2 may be a variety of Database?
It is AN Integrated RDBMS.
An access path is also during which sequence?
It may be in Arrival & Keyed sequence
To change constant field outlined on RLU screen that field level keyword ought to be used?
DFT (Default)
Space & Skip are that level keywords?
Field & Record
A be part of Logical File has what number Record formats?
1
A Multiple format Logical File is additionally celebrated as?
Union File
How will Union file maintains Record formats?
1 Record format for every PF
Records is Read/Update/Deleted with that file?
Simple Logical File & Physical File.
Which type of object is employed in DB2/400?
*FILE
What is SQL?
SQL is Associate in Nursing interface for programming language.
A Query is displayed while not saving it?
True
Which area unit the question choice criteria, which might be during a Query?
LIST
To add a file to the ‘File Selection’ choice of a question , the perform key to be ironed is?
F9
A query is run within which mode?
Batch & Interactive
What is the values SQLCOD once there’s a slip in taking the records per the choose statement?
-ve price
A file cannot have quite one distinctive key?
False
DLCOBJ command is obligatory for removing lock on any object?
False
Are you Looking for IBM AS 400 Online Training? Please Enroll for Demo IBM AS 400..! |
What is a Journal?
A Journal is AN object used primarily to record changes to knowledge in an exceedingly PF.
Which square measure the DB2 tools to shield Integrity of the database?
Journaling & Commitment management, denotative Integrity Embedded SQL & Object/Record Locks.