Interested to Buy Any Domain ? << Click Here >> for more details...
In SPUFI suppose you want to select maximum of 1000 rows,
but the select returns only 200 rows. What are the 2
SQLCODEs that are returned?
- 1 Answers
- 10387 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajesh melwani
Spufi returns two SQLCODEs as following:
{1} Return code of query
{2} Return code based on limit of Spufi
In the above case, if rows returned are less than limit,
then SQLCODE will be +0 for {1} and +100 for {2}.
If rows fetched are more but because of Spufi limit only
few rows are displayed and +0 will be returned for {1} and
{2}.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Define declaration generator (dclgen).
What is dbrm library?
What is bufferpool in db2?
What is the use of with ur in db2?
What is the use of commit in db2?
Name the lockable units in DB2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is db2 catalog database?
What are the various isolation levels possible?
What is the syntax for FETCH in DB2 ?
What is the role of data manager in the db2 database?
How many databases can be created inside an instance in db2 ?
How is a typical db2 batch pgm executed?
How to restart a DB2 program?
How do we specify index to include or not during bind process.
