is it possible to get -811 error when you use cursors. why?
Answers were Sorted based on User's Feedback
When you are fetching cursor without declaration.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / purushothr
Yes it is possible only in cursor. if u trying to retrieve
more than one row at the same time by using cursor then -
811 error ll come.
| Is This Answer Correct ? | 6 Yes | 14 No |
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
pls tell me abt the normalization five types....
What is the syntax for creating a table in the db2 database?
Explain the function of data manager.
What are the various isolation levels possible?
What is the SQL Communications Area and what are some of its key fields?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
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 ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
What is copy pending and check pending in db2?
How does coalesce work?
What are simple, segmented and partitioned table spaces ?
Are views updatable ?