| Other DB2 Interview Questions |
|| Asked @
|What is Reorg Recovery? when will you run it?
|why should we bind the DB2 program . What if we did not
BIND a BD2 program ??
|Hi , I am posting some interview ques .
what is the use of cursors ? what is the diff between
select and cursor ? bith are used for data retrival ..
|in the CURSOR declare statement, if i am using an where
clause and trying to compare the value with a host-varialble.
EXEC SQL DECLARE C1 CURSOR FOR
SELECT DEPTNO, DEPTNAME, MGRNO
WHERE ADMRDEPT = :ADM-DEPT
Where would i need to provide value to this host-variable in
the where clause. how could i pass value to this
host-variable to check it.
|what is the name of the default db2 catalog database?
|Write a query to retrive partial string.
|how do u update the faltfile into db2 table ?
|When do you use the IMAGECOPY?
|Suppose there are many duplicate records in a Db2 table.
What is the query to retrive only duplicate records?
|What is -904 sql code? How to resolve it?
|what is the use of cursors?
|what is diffrence b/w file-aid tool and file-aid utility???
|For more DB2 Interview Questions Click Here |