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
- 10309 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 picture clause of the null indicator variable?
What is auditing?
List out the three types of page locks that can be held.
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
What do you mean by rollback?
How many databases are there?
What is an alias and how does it differ from a synonym?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
what are extents?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What is deadlock?
What is access path in db2?
COBOL 
