10) 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

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

MAINFRAME

DB2

DETAILS

Question: 10) What is the use of VALUE function?

Answer: 1. Avoid -ve SQLCODEs by handling nulls and zeroes in computations

2. Substitute a numeric value for any nulls used in computation

Category	DB2 Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 8658 users
Added on	9/1/2014
Views	68129
Rate it!

Question: 10) What is the use of VALUE function?

Answer:

1. Avoid -ve SQLCODEs by handling nulls and zeroes in computations

2. Substitute a numeric value for any nulls used in computation

Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	9) How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?	View Answer
	8) My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?	View Answer
	7) Can you use MAX on a CHAR column?	View Answer
	6) What are aggregate functions?	View Answer
	5) How do you retrieve the first 5 characters of FIRSTNAME column of DB2 table EMP ?	View Answer
	4) How do you find the maximum value in a column in db2?	View Answer
	3) How do you select a row using indexes in DB2?	View Answer
	2) How do you eliminate duplicate values in DB2 SELECT ?	View Answer
	1) How would you find out the total number of rows in a DB2 table?	View Answer
	What are difference between version control and debugging tools?	View Answer
	why we use db2 with cobol why we cant use any other languages? what the main reason? what is disaster recovery?	View Answer
	What do the initials DDL and DML stand for and what is their meaning?	View Answer
	Explain the use of the WHERE clause. WHERE is used with a relational statement to isolate the object element or row.	View Answer
	What are foreign keys?	View Answer
	What is normalization and what are the five normal forms?	View Answer
	What is a DB2 plan?	View Answer
	What is a DB2 access path?	View Answer
	What is a DB2 bind?	View Answer
	What is an alias and how does it differ from a synonym?	View Answer
	What is a synonym? How is it used?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All DB2 Interview Questions & Answers - Exam Mode / Learning Mode