Q: dbimport with EXTEND SIZE, how?
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);