Re: drop default not null problem

David,

Just did:

CREATE TABLE temporal/TEST1 (C1 CHAR (10 ) not null DEFAULT '')
CREATE TABLE temporal/TEST2 (C1 CHAR (10 ) not null DEFAULT )

and ran:


select sys_tname, sys_cname, dftvalue, "default" from syscolumns where
sys_dname = 'temporal' and sys_tname like 'test%'
Result:

....+....1....+....2....+....3...
SYS_TNAME SYS_CNAME DFTVALUE
TEST1 C1 ''
TEST2 C1 ' '

So it seems that if I don't define a default value, it has nonetheless, one
that is different than if I specify just empty quotes as a default value
(just one blank, as opposed to none). .

Maybe this could help you with your item #3.

I agree that it seems to be a strange case, though...

HTH,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries