What error I will get if my select query gives multiple
row while executing a Cobol-DB2 program.How can I solve it
without using a cursor.
Answer Posted / nitin sharma
Hi,
You will get -811 SQLCODE if more than one rows will be
returned by your query.
To avoid this you can also use FETCH FIRST 1 ROWS ONLY in
your query like
SELECT * FROM EMP
FETCH FIRST 1 ROWS ONLY;
Hope this helps.
Nitin
Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is host variable in db2 cobol?
What is package in cobol db2?
What is the difference between dbm cfg and db cfg file in db2 ?
Is the primary key a clustered index?
i want to maintain uniqueness on pdf without make lf??????????
What is the physical storage length of time data type?
Is db2 a mainframe database?
Can you tell me how can you find out the # of rows updated after an update statement?
What is bind package and plan in db2?
What are types of indexes?
Is db2 a mainframe?
What is dbrm?
What is dbrm? What it contains? When it will be created?
What is netezza database?
Explain about rct.