Re: Q: dbimport with EXTEND SIZE, how?

Shout be EXTENT not EXTEND, you probally know this by now. ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Fax: 512-393-7296 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On 10 Jun 1996, Klaus Dobrindt wrote: } 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); }