Answer Posted / rami reddy
If single select returns more than one row then you get
SQLCODE = -811
Is This Answer Correct ? | 38 Yes | 3 No |
Post New Answer View All Answers
How many types of page locks can be held in db2?
What is sqlca’s maximum length?
What is the syntax for FETCH in DB2 ?
Mention some fields that are a part of sqlca.
Which component is used to execute the sql statements?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is role in db2?
How can you count the number of rows from a table tab?
What is consistency token in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is the role of the data page in the db2 database?
What does sqlcabc has?