[To: markm%zerbin.dev.cdx.mot.: DB Conversion]
----- Forwarded message # 1:
Received: from redriverad-emh1.army.mil by rrad05.army.mil id aa14760;
23 Aug 93 13:08 CDT
Received: from rrad05 by redriverad-emh1.army.mil id aa17807;
23 Aug 93 13:17 CDT
Date: Mon, 23 Aug 93 13:03:50 CDT
From: "cheryl@redriverad-emh1.army.mil" <cheryl@rrad05.army.mil>
To: markm%zerbin.dev.cdx.mot.com@RMY.EMORY.EDU
cc: cheryl@REDRIVERAD-EMH1.ARMY.MIL
Subject: DB Conversion
Mark,
Assuming you have a one-to-one table relationship in the new system.
You can do a schema of your current database by typing.
dbschema -d databasename > dbname.sql [return]
at the unix prompt. (Depending on the informix version)
in < 4.10 change directories to the directory that hold the
database and type the dbschema command.
In higher versions this may not be necessary/possible.
Then get into isql Query and run the following sql for each table
listed in the file dbname.sql. The .sql created is capable of
creating your tables in a system that is capable of running STANDARD
sql.
Each Table unload would look like this:
unload to "tablename_w/fullpathname_of_file_where_their_is_enough_space.unl"
select * from tablename;
(See page 2-137 of the Informix-sql Reference Manual 2.10 version)
Cheryl Gross
Red River Army Depot
Texarkana, TX
cheryl@redriverad-emh1.army.mil
----- End of forwarded messages