assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
how we will do null data selection in cobol-db2 program
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
What is the max length of sqlca?
Define db2 and its databases?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
what is load and unload in db2
wht happens if we close cursor with cursor with hold option?
What is ACQUIRE/RELEASE in BIND?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
What is syscat in db2?
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?
In terms of DB2 indexing, what is the root page?