Re: Q: dbimport with EXTEND SIZE, how?

The only problem with your sospos.sql file is that you've misspelled the keyword EXTEND. It should be EXTENT. So just make that simple change and the schema should load fine! Enjoy, Tracy } } I'm trying to import into online 7.10 runtime a database from } informix online 5.x, but i want to include EXTEND SIZE and LOCK MODE options } for certain tables. } } Without these options there was no problem importing the database, when i } edit my "database".sql file in the "database".exp directory, } I get a syntax error. } } Database is named sospos, here a short excerpt from sospos.sql: } } } { DATABASE sospos delimiter | } } } grant connect to "root"; } grant connect to "public"; } grant dba to "birgit"; } grant dba to "klaus"; } } { TABLE "sospos".sos row size = 456 number of columns = 94 index size = 135 } } { unload file name = sos____255.unl number of rows = 6613 } } } create table "sospos".sos } ( } fehlerkz char(1), } ... a lot of fields... } datlae date } ) EXTEND SIZE 10000 NEXT SIZE 2000 LOCK MODE ROW; } ^ Syntax Error : 201 } revoke all on "sospos".sos from "public"; } } create unique index "sospos".i_sos on "sospos".sos (mtknr); } create index "sospos".i_name on "sospos".sos (nachname,vorname); } create index "sospos".i_gebdat on "sospos".sos (gebdat); } create index "sospos".plz on "sospos".sos (poplz); } -- ========================================================================= = Tracy W. Nedd = = Banctec Inc. - DBA = = Silver Spring, Md = = tracyn@asd.banctec.com = ========================================================================= = ALL RIGHTS RESERVED. = = This posting is copyright and may be used only for the purposes = = of professional study, or the professional exchange of information. = = Use of this posting by any commercial organization for the purposes = = of vilifying another is explicitly prohibited. = =========================================================================