What is the purpose of the WHENEVER statement ?
The WHENEVER statement is coded once in the host program to control program actions depending on the SQL-CODE returned by each sql statement within the program.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is the purpose of the FILE STATUS clause in the SELECT statement ? 10.08.08
The FILE STATUS field identifies the field that VSAM uses to provide information about each I/O operation for the file....What is the purpose of the finally clause of a try-catch-finally statement? 22.05.07
The finally clause is used to provide the capability to execute code no matter whether or not an exception is thrown or caught....What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it? 02.04.07
To use a Native SQL statement, you must precede it with the EXEC SQL statement, and follow it with the ENDEXEC statement as follows: EXEC SQL [PERFORMING ]....How can you use PreparedStatement? 26.10.06
This special type of statement is derived from class Statement.If you need a Statement object to execute many times, it will normally make sense to use a Prepa...What are the different types of Statements? 26.10.06
Regular statement (use createStatement method), prepared statement (use prepareStatement method) and callable statement (use prepareCall)...How can you create JDBC statements and what are they? 26.10.06
A Statement object is what sends your SQL statement to the DBMS. You simply create a Statement object and then execute it, supplying the appropriate execute met...What is the advantage of using PreparedStatement? 22.10.06
If we are using PreparedStatement the execution time will be less. The PreparedStatement object contains not just an SQL statement, but the SQL statement that h...What is the purpose of a statement block? 16.03.06
A statement block is used to organize a sequence of statements as a single statement group....What is the difference between a break statement and a continue statement? 07.03.06
A break statement results in the termination of the statement to which it applies (switch, for, do, or while). A continue statement is used to end the current l...What is the purpose of the finally clause of a try-catch-finally statement? 07.03.06
The finally clause is used to provide the capability to execute code no matter whether or not an exception is thrown or caught....