Date field as 'NULL'

[Former Member]

Hi!

I want to insert a 'NULL' value in date field in database.

If I leave the field blank it inserts '00000000'.

If I specify a space, it inserts ' / / '

How do I insert null for Date. Other programs pick up this Null value, so I want to insert it as Null only.

Thanks.

Edited by: Nikhil DOZ on Aug 26, 2008 10:58 PM

[Former Member]

Hi!

I want to insert a 'NULL' value in date field in database.

If I leave the field blank it inserts '00000000'.

If I specify a space, it inserts ' / / '

How do I insert null for Date. Other programs pick up this Null value, so I want to insert it as Null only.

Thanks.

Edited by: Nikhil DOZ on Aug 26, 2008 10:58 PM

[Former Member]

initial value for date is '00000000'.

[Former Member]

I want it stored as NULL, because there is another program which check date = NULL in select statement.

How can I do this?

[Former Member]

Hi,

Try to have the char datatype for that date field to have the NULL value. Have the lenght of the field as CHAR(8) or CHAR(10) for your requirement. Here we can have spaces ot NULL as the field value.

We cant have NULL value for the field whose datatype is of DATE or DATS type. This is posible in Oracle and other databases.

Regards

Lekha

[karan007]

Hi,

my_element->set_attribute_null(

EXPORTING

name = `<Attribute_Name>` ).