RE: Create Table with Fragmentation - Syntax Error

oh my - it really has been a looonngg day! Thanks. I figured it was something stupid. Laurie >>> "Plugge, Joe R." <JRPlugge@west.com> 5/6/2010 12:56 PM >>> Could you have possible typo’d one of your dbspace names? fragment by round robin in mv1, mv2, m3, mv4 From:informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Laurie Gustin Sent: Thursday, May 06, 2010 1:53 PM To: informix-list@iiug.org Subject: Create Table with Fragmentation - Syntax Error 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