How to handle null values in db2

Answer Posted / ankitha

you can use value function or null indicators if you want to
handle nulls in program.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which command is used to connect to a database in DB2 ? Give the Syntax.

689


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

668


How to retrieve rows from a db2 table in embedded sql?

845


List down the data types in the db2 database.

716


Mention the various locks that are available in db2.

697






What is difference between isnull and coalesce?

688


What is view db2?

721


What is catalog database in db2?

749


What is null indicator in db2?

716


What is deadlock in db2?

677


Give a brief description of db2 isolation levels?

688


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1359


List out the data types available.

797


What is rebind in db2?

668


What do you mean by commit and rollback?

680