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
- 5318 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
What is concurrency?
What is ibm db2 used for?
What is the connection string to connect to the DB2 Database ?
What is the physical storage length of date data type?
Is the primary key a clustered index?
What is universal database?
What is a db2 tablespace?
What are packages in db2?
What is ibm db2 client?
How does cobol compile db2 program?
What is the use of reorg in db2?
What is image copy in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Are views updateable?
What is dbrm? When it will be created?
