Hi !
There are more people out there who need a good SQL book than I thought:
NULL ist _not_ "not specified". NULL is a special Value .. .. for example
you can define that a column has a default value of NULL if you don't
specify a value.
If you wan't the DB to use the default value, you have to use the keyword
DEFAULT or you just don't set it by specifing only the columns you want
to set in the insert (as i wrote an example before).
Ralf
> Hi,
> Even inserting a null on default columns stores a null and not the default.why? I
>thought null meant "not specified". What is the SAPDB version of the definition of
>NULL?
> Regards,
> Ajit
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>
--
theCo.de AG
Oranienstr. 10-11, 10997 Berlin
fon +49 30 617 897-0 fax -10
[EMAIL PROTECTED] http://www.theCo.de
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
