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
- 9499 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 |
What is a DB2 catalog?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
How would one remove old reorg information from the DB2 catalog?
On the create tablespace, what does the CLOSE parameter do?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
how to resolve -818 error. how to see timestamp token in load module and plan
What is buffrpool? Where we use it ?
What techniques are used to retrieve data from more than one table in a single SQL statement?
Which is faster delete or truncate?
Before you give the explain statement, what are the prerogatives?
What does db2 mean?
COBOL 
