Re: Q: dbimport with EXTEND SIZE, how?

Klaus , Try using EXTENT instead of EXTEND. -- Rajiv Jhaveri DBA ============================================================= Voice : (908) 949 7987 Fax : (908) 949 1726 E-mail: rajivp@qsun.ho.att.com ============================================================= -------------------------------------------------------------- } From: kld@klee.hdk-berlin.de (Klaus Dobrindt) } Content-Type: text } } 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); } }