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?
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 |
how will you retrieve first record in table
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
What is the clustering index in the db2 database?
What does db2 stand for?
How to select the duplicate rows from a table?
How to define the a field which accepts value till 99999.99 in db2
What is the difference between TYPE 1 index & TYPE 2 index
What are simple, segmented and partitioned table spaces ?
What is buffer pool?
What are the advantages of using a PACKAGE?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
How to connect to db2 database from windows command line?