DB2 9 Family Fundamentals(000-730) - Q & A Read and Download several question and answers for the IBM DB2 9 certification exam. Section 1 - Planning (14%) Knowledge of restricting …
Options on DECLARE CURSOR Use FOR READ/FETCH ONLY or WITH UR for retrieval only cursors. Use OPTIMIZE when you know the accurate number of rows that will be fetched …
Useful List of SYSIBM tables SYSCHECKDEP Column references for CHECK constraints SYSCHECKS CHECK constraint specifications SYSCHECKS2 (V7) Information about CHECK …
Ranking and Numbering for Records in DB2 DB2 supports ranking and numbering in much the same way that Oracle does. The available functions are: ROW_NUMBER(), which simply numbers …
Selecting first few rows in DB2 DB2’s method of performing a Top-N query is the FETCH FIRST clause. You can append these variations to a regular SELECT query: FETCH FIRST …
DB2 Index with Expressions Prior to DB2 9, the create index statement only allowed you to use the column name from the table the index is being built on. The same …
Like the DB2 LIKE The LIKE phrase defines a mask for comparing characters: WHERE COL_VAL [NOT] LIKE mask A mask may be a host variable or a literal enclosed …
Handling NULL in DB2 The value of an indicator variable tells the status of a row after a query. Host Variable: 01 FILLER. 05 WS-AMOUNT PIC S9(5)V9(2) COMP-3. 05 …
Isolation level in DB2 The list of isoloation leves are listed below. SERIALIZABLE(Repeatable read (RR)) REPEATABLE READ(Read stability (RS)) READ COMMITTED(Cursor …
Points to Ponder on DB2 NULL NULLs can present problems because they are handled differently by different computers and the collating sequence is inconsistent with …
Explanation on DB2 Explain When an SQL is executed against or bound to a DB2 database, DB2 Optimizer tool defines the access path used to access the data. This access …
Verification of DB2 Consistency token When a Job abends at a program due to bind error with SQL code of -805 or -818 then generally there is issue with consistency token (often …
