CREATE MULTISET TABLE testdb.testio ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
setting VARCHAR(128) CHARACTER SET LATIN CASESPECIFIC NOT NULL,
date_value DATE FORMAT 'YY/MM/DD',
NotNullDec_value DECIMAL(20,2) NOT NULL DEFAULT 1.02 ,
PRIMARY KEY ( setting ))
However, it works if the "NotNullDec_value" column is not there. Can anybody help me on this?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.