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
- 9900 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 the syntax for FETCH in DB2 ?
What is a Foreign Key?
How do I import a csv file into db2?
What is the result of open cursor statement?
What does db2 mean?
What is a dbrm in db2?
Mention the location where the output received from explain statement is stored.
What os does db2 run on?
What is runstats utility in db2?
What is a bind in db2?
What is the physical storage length of the data types date, time, and timestamp?
What is the maximum number of columns in a db2 table?
What is db2 purescale?
How can deadlocks be resolved?
What are db2 tables?
