I am trying to insert value into a table by selecting from another table.
say into table1 from table2
table1-field1,field2,field3(nullable and type date),field4
table2-fld1,fld2
If I give

Insert into table1
select fld1,'abc',NULL,fld2
from table2

I get an error NULL is not a field in the inserted or selected table.

If I give

Insert into table1
select fld1,'abc','',fld2
from table2

It gives invalid date format error message.

Could someone please tell me how I can insert Null value to date field by using select statement??????????

INSERT INTO TABLE1 (FIELD1, FIELD2, FIELD4)
SELECT FLD1, 'abc', FLD2 FROM TABLE2

In DB2 V7 there is the function NULLIF, which returns NULL, if both arguments are the same, i.e NULLIF(CURRENT DATE, CURRENT DATE) results in NULL.

You can use
cast(null as date)
in place of your null in the original post ..

But n_i 's suggestion is the best

Cheers
Sathyaram