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
- 10312 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 |
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
How to solve S0C7 abend with out using DISPlay in 10 mins?
How does the processing of a correlated subquery differ from a non correlated subquery?
What is view db2?
can we drop column from a table
What is reorg?
What is ACQUIRE/RELEASE in BIND?
where can we use index and subscript ? with example ?
How do I copy a table in db2?
How do I delete a table in database?
What is dbrm library?
COBOL 
