Interested to Buy Any Domain ? << Click Here >> for more details...
Select empno, sal from emptbl where empno < 101.By this
query can we fetch first 100 recs? where empno is primary
key.It won't throw -811 error? if it wont,then what is use
of cursor technique while fetching first 100 recs.
Please need more clarification.
- 2 Answers
- 6154 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhu t
If the to fetch empno and sal from emptble is written in
embedded sql then it will give sqlcode -811.
yes this query fetches first 100 records of employee table.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Can you use max on a char column?
What is the connection string to connect to the DB2 Database ?
What are union and union all?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is precompiler in db2?
How do you select a row using indexes in db2?
Can there be more than one cursor open for any program?
What are the different types of base tables?
What is release/acquire in bind?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is difference between alias and synonym in db2?
What is the role of the data page in the db2 database?
How do we specify index to include or not during bind process.
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
is it compulsory commitment control in journal?
