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
- 9893 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 the difference between group by and order by?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
How to fetch the uncommited data from table ?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
What is check constraint. Explain with example.
What is a Resource Control Table(RCT)? Describe its characteristics.
can all users have the privilage to use the sql statement select * (dml)?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
What is the latest version of ibm db2?
how can we find nth max salary from A table
How can you count the number of rows from a table tab?
What are bind parameters in db2?
COBOL 
