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
- 10308 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 check constraint.
what is diffrence b/w file-aid tool and file-aid utility???
What are foreign keys in db2?
What is universal database?
What are db2 objects?
What are the rules for db2 programming?
What is access path in db2?
How do I copy a table in db2?
What does db2 plan contain?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How do I delete a table in db2?
What does sqlcabc has?
What are the full forms of spufi and dclgen and why are they used?
What is the role of schema in the db2 database?
What is a dbrm in db2?
