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
- 10316 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Where is the access path logic created by the DB2 Optimizer stored?
What are the prerogatives?
What is null indicator in cobol db2?
what is the responsibility of the construction superintendent
How does the processing of a correlated subquery differ from a non correlated subquery?
How does one remove entries from the SCT02 table?
How do I start db2 in windows?
what is a plan and how do you refer the plan in the program?
how can u nderstand the sql stmts executed successfully or not ?
What does the sqlcode of -818 pertain to?
How to execute stored procedure in db2 command editor?
What is db2 purescale?
COBOL 
