Re: Help with Exporting Informix's Data base over to ASCII
In article <4ln36d$hej@bigboote.WPI.EDU> minh@wpi.edu writes:
>Subject: Trying to export from Informix SQL V2.10 database on a Unix
>system.
>The museum has a dedicated database as follows:
>
>Hardware Operating System
>Altos 3000 Altos UNIX
>Intel 80386 System V 386RT
> V5.3eS2
>
>DataBase DataBase Development Language
>Informix-SQL INFORMIX-4gl RDS
>V2.10.03KB0 V1.10.03KBO
>
>The application is a custom package written around the turn of the
>decade
>(1989-1991). ISAM seems to be part of the picture as there are
>occasional
>references to ISAM in our documentation. I have extensive hardware
>and
>network experience, have worked as a programmer and have database
>experience. However I have never used Informix and there are no
>Informix or
>SQL programmers on my staff at this time.
>
>The Altos system has an Ethernet 10-Base-2 connector but does not seem
>to
>support Ethernet with the current software. Neither does it have
>TCP/IP
>Server or NFS as far as I can tell. It does have UUCOPY and supports
>serial
>terminal connections at 9600 baud.
>
>We currently run the database application(s) using Altos7 terminals,
>Wyse60
>terminals and two PC's using Windows for Workgroups V3.11 and
>ICE.TEN.Plus, a
>terminal emulator package written by James River Group, Inc. from
>Minnesota.
>
>Problem Statement
>
>We will soon be replacing our software with a package written in
>Oracle and
>need to port our data to a newer Intel based server. I am interested
>in
>capturing all existing data and meta-data and exporting it into a
>format our
>future vendor can handle.
>
>Please tell me if we would be able to connect to the database using
>Data
>Junction. Will Data Junction connect to the INFORMIX database over a
>terminal port? Will it work satisfactorily over a 9600 baud serial
>connection from the PC? Is there any other (faster) way to connect to
>the
>database?
If you want the database dictionary definitions, try
dbschema -d <database name> <outputfilename>
without the <> brackets, natch. This will give you a file with all the SQL
database table, index etc definitions.
As for the data, I think you're SOL unless:
you have isql
you have a RDS-4GL dev system
the original app builder wrote dump programs
someone else has a bright idea??
If you get *really* stuck, I still have ISQL and R4GL/RDS for release 2.10
for unix floating around here somewhere. (Never throw anything away. I
even have a MSDOS 2.10 system on the shelf). Ask me and we might be able to
work something out, depending.
Don't really know if I should help a person migrate TO Oracle, though :-)
Peter Wiley