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
- 9911 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 |
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
Explain packages.
What are the benefits of using the db2 database?
Explain the EXPLAIN statement?
What is the clustering index in the db2 database?
What do you need to do before you do EXPLAIN?
What r the comman abends in db2, jcl and cobol???????
What is cobol db2?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
what is dynamic cursor?gives syntax for this?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
What keyword does an SQL SELECT statement use for a string search?
COBOL 
