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
- 10213 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
What is an instance in db2?
What are the two types of logging in the db2 database? Explain them.
How to compare data between two tables in db2?
What is cobol db2?
How do I delete a table in database?
What is a db2 schema?
What is db2 bind?
What is collection in db2 bind?
How will you return the number of records in table?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
How can you find out the # of rows updated after an update statement?
What is the difference between oracle and db2?
What does reorg do in db2?
How many databases are there?
Is db2 a database?
