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
- 10295 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
How do you pull up a query which was previously saved in qmf?
What is db2 instance?
What is check constraint in db2?
What is the use of value function?
Explain packages.
What are the bind parameters ibm db2?
What is check constraint. Explain with example.
How can we read records for specific member in CL? AND rpg?
What is package in db2 mainframe?
What is db2 bind?
What is a db2 package?
Explain package in db2 and its advantages?
Is ibm db2 free?
What does db2 mean?
Can one database have multiple instances?
