Mention some fields that are a part of sqlca.
how can u retrieve the data from null values using applicaion program.
what is the use of cursors?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How can you do the explain of a dynamic sql statement?
Why do we bind in db2?
What is a page?
What is the latest version of ibm db2?
What is a clustering index?
Q3. How will you fetch duplicate values from a DB2 table?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?