Re: Create Table with Fragmentation - Syntax Error
It all looks right to me. What is the error? Is it -201 (Syntax) or something else? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, May 6, 2010 at 2:53 PM, Laurie Gustin <lgustin@utah.gov> wrote: > 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 > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >
On 06/05/2010 20:33, Art Kagel wrote: > It all looks right to me. What is the error? Is it -201 (Syntax) or > something else? > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com > <http://www.advancedatatools.com>) > IIUG Board of Directors (art@iiug.org <mailto:art@iiug.org>) > > See you at the 2010 IIUG Informix Conference > April 25-28, 2010 > Overland Park (Kansas City), KS > www.iiug.org/conf <http://www.iiug.org/conf>; > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated > nor those of the entities themselves. > > > > On Thu, May 6, 2010 at 2:53 PM, Laurie Gustin <lgustin@utah.gov > <mailto:lgustin@utah.gov>> wrote: > > 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 <mailto:lgustin@utah.gov> > 801-965-4410 > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org <mailto:Informix-list@iiug.org> > http://www.iiug.org/mailman/listinfo/informix-list > > 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 64 next size 128 lock mode row; # ^ # 217: Column (vl_lien_stat_desc) not found in any table in the query (or SLV is undefined). # 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 dbspace_1, dbspace_2 extent size 64 next size 128 lock mode row; Table created. "It's hard enough to remember my opinions without remembering my reasons for them You're confusing me now I'm not gonna give you an example I can't remember an example"