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 many databases can be created inside an instance in db2 ?
What is db2 bind process?
What is the use of db2?
How can deadlocks be resolved?
Discuss about db2 bind?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
define clustering index.
What is collection in db2 bind?
What is a base table?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
What is the command used by TSO users to invoke DB2?
What is node in db2?