how to resolve -811
Answers were Sorted based on User's Feedback
Answer / srini
Declare cursor instead of singleton select,as the query you
are running has multiple records.
Is This Answer Correct ? | 3 Yes | 0 No |
how to check the table is empty or not?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
What is the difference between IN subselects and EXISTS subselect?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What is the use of db2?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
what is the sqlcode -501
What are bind parameters in db2?
how to fetch multiple records without using cursor
What is index in db2?
What is the physical storage length of the data types date, time, and timestamp?