Unload from Table with DSNTIAUL delimited by pipe symbol

suzeet · New User Joined: 16 May 2005 Posts: 54

Hi All,

I am trying to Unload few fields of a DB2 table using DSNTIAUL. I need to
unload into a flat file in a pipe(|) separated format.

I have used a query similar to the below one for unloading.

Select Empno
,char('|')
,Emp_name
,char('|')
,Emp_addr
,char('|')
,Emp_city
from table

I want to put "NULL", if any of the column value contains NULL

Thanks in advance.

Marso · Posted: Wed Dec 17, 2014 8:10 pm

use the COALESCE function:
COALESCE(Emp_addr,'NULL')