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

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].