| Other DB2 Interview Questions |
|| Asked @
|how to resolve -818 error. how to see timestamp token in
load module and plan
|why db2 is called as universal database?what is the storage
capacity of db2v9 n what are the advantages of db2
|how to copy the host variables from ps file into cobol program
other than include statement
|Suppose there are many duplicate records in a Db2 table.
What is the query to retrive only duplicate records?
|What's the maximum number of volumes that can be added to a
|how do you resolve -805?
|Suppose we have a query for update
set col1 = 'val1'
where col2=(select .... from ...)
suppose the subquery does not return any record, what will
happen to update?
|database DSNDB01 means
answer with reason please
|I have a DB2 table which has 1000 rows.after udatingg first
110 rows, my job abends. Now what I have to do if I want to
restart the job next time so that it should start updating
from 111th row (without updating first 110 rows again).
|I need to view the number of tables existing under one
particular Owner. Is it possible? If so, pl give the SQL
query for this?
|One program calling 5 subprograms, its a cobol db2 program,
after precompilation how many plans and packages will
|What is the function of the Data Manager?
|For more DB2 Interview Questions Click Here |