How to remove null indicators while unloading a table

Priyesh Tewari · New User Joined: 24 Jun 2008 Posts: 7 Location: Pune

Hi,
I am trying to unload data from table using HPUNLOAD utility. But null indicator appear in that unload file. Even after using COALESCE function The null indicator appear in the file. Can somebody help me on this

wfs · New User Joined: 04 Sep 2008 Posts: 1 Location: USA

are you sure it's the NULL indicator you're seeing.

If the column in question is a string, then the COALESCE(colname,'XXX')

would result in a VARCHAR output column, so it would be preceded by the LENGTH attribute.

To get rid of the length use SUBSTR

SELECT
....
SUBSTR (COALESCE(colname,' ') || space(20), 1, 10) etc