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
Answer / anonumous
it would be FETCH 300 ONLY
|Is This Answer Correct ?||0 Yes||0 No|
what is differnece between DROP TABLE & DELETE TABLE .
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
What is isolation level?
what is the difference between declaring the cursor in WS section and Procedure division?
What is a synonym? How is it used?
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
Describe the elements of the SELECT query syntax?
what is SMP/E? and what are the major steps of it? thanks...
What is a subselect? Is it different from a nested select?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?