Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of the WHENEVER statement?
- 1 Answers
- 5170 Views
- I also Faced
- E-Mail Answers
Answer / s
WHENEVER is used to specify whether to continue processiong
or branch to another area in your program.
EXEC SQL
WHENEVER CONDITION ACTION
END-EXEC
CONDITION can be SQLWARNING, SQLERROR, NOT FOUND conditions
The ACTION can be CONTINUE or GO TO to branch to another
area in your program
| Is This Answer Correct ? | 0 Yes | 0 No |
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
List out the buffer pools in db2
What is the significance of DB2 free space and what parameters control it?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What are concurrency issues?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
Why cursor is used in db2?
What are the three types of page locks that can be held?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
What is the purpose of the DSNC transaction ?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
COBOL 
