What is the use of VALUE function?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the use of VALUE function?

1. Avoid -ve SQLCODEs by handling nulls and zeroes in computations
2. Substitute a numeric value for any nulls used in computation

(Continued on next question...)

Other Job Interview Questions

• How do you eliminate duplicate values in DB2 SELECT ?
• Are views updateable ?
• How do you read vsam file?
• What happens when you say OPEN CURSOR?
• When you COMMIT, is the cursor closed? - drona questions–
• In the WHERE clause what is BETWEEN and IN? –
• Is it mandatory to use DCLGEN? If not, why would you use it at all?
• What does WITH HOLD option do ?
• What is index cardinality? –
• Is DECLARE CURSOR executable?
• More...