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?



In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. Wh..

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

Post New Answer

More DB2 Interview Questions

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,


what is the Foreign key? explain?

2 Answers  


how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,


what is dynamic cursor?gives syntax for this?

1 Answers   TCS,


1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers  


What is a clustered index?

1 Answers  


What are foreign keys in db2?

0 Answers  


What is the difference between db2 and oracle?

0 Answers  


What is ibm db2 used for?

0 Answers  


What is a db2 package?

0 Answers  


Explain the function of data manager.

0 Answers  


Mention the various locks that are available in db2.

0 Answers  


Categories