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
- 10237 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 are some SQL aggregates and other built-in functions?
db2 restart logic ?
what are the max. & min. no. of partitions allowed in a partition tablespace?
What do the initials DDL and DML stand for and what is their meaning?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
What is a NULL value? What are the pros and cons of using NULLS?
What is the physical storage length of the data types date, time, and timestamp?
How can you count the number of rows from a table tab?
What is an intent lock?
how to check the table is empty or not?
What is a trigger in the db2 database?
What is database manager in db2?
COBOL 
