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 (AT) utah (DOT) gov
801-965-4410

Could you have possible typo'd one of your dbspace names?
fragment by round robin in mv1, mv2, m3, mv4

From: informix-list-bounces (AT) iiug (DOT) org [mailto:informix-list-bounces (AT) iiug (DOT) org] On Behalf Of Laurie Gustin
Sent: Thursday, May 06, 2010 1:53 PM
To: informix-list (AT) iiug (DOT) 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 thatwould 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 (AT) utah (DOT) gov
801-965-4410

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 (AT) iiug (DOT) 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 (AT) utah (DOT) gov> wrote:

On 06/05/2010 20:33, Art Kagel wrote:
( 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"

oh my - it really has been a looonngg day! Thanks. I figured it was
something stupid.

Laurie

Could you have possible typo’d one of your dbspace names?
fragment by round robin in mv1, mv2, m3, mv4



From:informix-list-bounces (AT) iiug (DOT) org
[mailto:informix-list-bounces (AT) iiug (DOT) org] On Behalf Of Laurie Gustin
Sent: Thursday, May 06, 2010 1:53 PM
To: informix-list (AT) iiug (DOT) 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