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
- 10294 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 do you mean by storage group (stogroup)?
Discuss about db2 bind?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
what is + sign and -ve sign for sql code ?
How many Buffer pools are there in DB2 and what are they?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
Which catalog table stores referential constraints?
what is a trigger and types of triggers
What is the function of the Data Manager?
What is auditing?
How do you check for a null value in a db2 column?
COBOL 
