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
- 10386 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 cobol db2?
Define declaration generator (dclgen).
Explain various types of locks in db2?
How do I add a column in db2?
pls explain the precompilation process of cobol-db2 pgm
Name some fields from SQLCA.
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is buffer pool and list some of them?
where can we use index and subscript ? with example ?
What is load replace in db2?
What is the error code -803 ?
What Utility is used to migrate DB2 from one release to the next?
COBOL 
