To display null value with user specified name either Null or br1 etc

[Jeya Bright]

Dear students,

One of the student raised this question

In a table when i fetch data it comes with some rows with data and
some rows with null.

ie
EMPNO

aaaaa
bbbbb
ccccc
--------
--------
ddddd
eeeee

like this...ie after row ccccc it is having null displayed as --------

The Question is i want these null value should be displayed in word as NULL
How you do it?

Soln:-

In db2 there is a function called value

SELECT VALUE(EMPNO,'NULL') FROM EMP

Regards,
P.Jeya Bright
Porur,
chennai-600116
PH:044-22522560
Mob:9941540250