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
- 10391 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 are the disadvantages of using VARCHAR?
Which command is used to remove all rows from a table?
how to resolve -818 error. how to see timestamp token in load module and plan
Once you create a view, where would information about the view be stored?
How would you print the output of an SQL statement from SPUFI?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
What is role in db2?
I use CS and update a page. Will the lock be released after I am done with that page?
What's the difference between DB2 active log and archive log? Thanks a lot...
Can there be more than one cursor open for any program?
How is the SUBSTR keyword used in sql?
Name some fields from SQLCA.
COBOL 
