IDS 11.50 FC6X3
Suse 10.2
Can anyone tell me what is wrong with the following create table statement? I keep getting a syntax error. If I take the fragment by clause out, it will pass a syntax check. Is there something in this table definition that would prevent fragmentation?
create table "informix".veh_lien_holder
( vl_idx serial8,
vl_veh_id integer not null ,
vl_addr_set_id integer,
vl_lien_hold_name char(40) not null ,
vl_hm_phone char(15),
vl_bus_phone char(15),
vl_lien_date date,
vl_lien_release_dt date,
vl_lien_stat_desc char(15),
primary key (vl_idx) constraint pk_vehlienhldr
) with vercols with crcols with replcheck
fragment by round robin in mv1, mv2, m3, mv4
extent size 60000 next size 102460 lock mode row;
Thanks!
Laurie
Laurie Gustin
IT Programmer Analyst
Department of Public Safety
lgustin@utah.gov
801-965-4410