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
- 10239 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 JOIN and different types of JOIN.
Is schema the same as database?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is a buffer in memory?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
how do you resolve -805?
What is the difference between Primary key and unique index?
Which transaction use a command thread ?
What is the physical storage length of time data type?
What is the maximum number of columns in a db2 table?
What is a clustered index?
COBOL 
