unable to create BLOB/TEXT columns for HEAP table

[Jack Ling]

Hi,


I'm trying to create a heap table. But there is an error saying that I can't use BLOB/TEXT columns for HEAP. Understand, but my table does NOT have BLOB type fields, only have common fields like char, varchar (*I've even change the varchar into char afterwards). Here is my table structure. Please give me guidelines. Thanks, Jack Ling:


CREATE TABLE TABLE_HEAP
(
LIC_NO char(6) NOT NULL,
ADDRESS char(40) NULL,
TEL char(8) NULL,
FAX char(8) NULL,
CO_CONTACT char(50) NULL,
CO_NAME char(50) NULL,
M_STREET char(50) NULL,
M_STREET1 char(50) NULL,
M_BLDG char(50) NULL,
M_BLDG1 char(50) NULL,
M_AREA char(30) NULL,
M_DIST char(3) NULL,
IN_STREET char(50) NULL,
IN_STREET1 char(50) NULL,
IN_BLDG char(50) NULL,
IN_BLDG1 char(50) NULL,
IN_AREA char(30) NULL,
IN_DIST char(3) NULL,
AREA_CODE char(3) NULL,
CODE char(3) NULL,
FILE_REF char(12) NULL,
RMS_REF char(12) NULL,
WORK_TYPE char(3) NULL,
LIC_DATE date NULL,
WIPE_TEST char(1) NULL,
SOURCE_TYPE char(1) NULL,
MED_EXAM char(1) NULL,
INSTRUMENT_REMARK char(100) NULL,
LICENCE1 char(60) NULL,
LICENCE2 char(75) NULL,
LICENCE3 char(75) NULL,
PURPOSE1 char(60) NULL,
PURPOSE2 char(75) NULL,
PURPOSE3 char(78) NULL,
NOTE1 char(75) NULL,
NOTE2 char(75) NULL,
NOTE3 char(75) NULL,
EQUIP_DESC char(762) NULL,
COMP_SV char(50) NULL,
PRINT_MADD1 char(75) NULL,
PRINT_MADD2 char(75) NULL,
PRINT_SADD1 char(75) NULL,
PRINT_SADD2 char(75) NULL,
DISP_NO char(6) NULL,
AMEND_ID char(6) NULL,
AMEND_DATE date NULL,
EMAIL char(50) NULL,
STATUS char(1) NULL,
CREATE_DATE date NULL,
CLOSE_DATE date NULL,
LIC_PERIOD smallint NULL,
organization char(8) NULL,
renewed_date date NULL,
modify_renewed_date date NULL,
licence_sys_date date NULL,
close_sys_date date NULL,
comp_name_chn char(60) NULL,
default_language_content char(1) NULL,
default_language_company char(1) NULL,
inactive_date date NULL,
create_sys_date date NULL,
PRIMARY KEY (LIC_NO)
) TYPE=HEAP;