Exporting data from an ISAM db – Informix Archive

Phil Grace — Thu, 20 Jan 2000 12:31:24 +0000 — source: Informix-list mailing list archive (1991-1998)

Hi, I need to export data from an ISAM UNIX database into a flat file, so that it can be imported in a new application. I know nothing about the platform it runs on or any version information, but I was wondering if anyone had any advice or insight into how easy or difficult this is going to be. Are we likely to find database tools at the customers that will enable us to export the data ? TIA Phil.

↪ replying to Phil Grace

Jonathan Leffler — Fri, 21 Jan 2000 06:32:08 GMT — source: Informix-list mailing list archive (1991-1998)

Phil Grace wrote: > I need to export data from an ISAM UNIX database into a flat file, so > that it can be imported in a new application. > > I know nothing about the platform it runs on or any version > information, but I was wondering if anyone had any advice or insight > into how easy or difficult this is going to be. > > Are we likely to find database tools at the customers that will enable > us to export the data ? It depends on how much you know about the data in the C-ISAM files. If you can tell where the fields end, then it isn't too hard. If you can't, it is near enough impossible. You need to know the types, too. And if the C-ISAM has variable length records, it is going to be rather difficult to do manually. You could look up DataJunction for a tool, or you could write your own. Whether the client site has any depends on whether anybody foresaw a need to unload data into an ASCII format. Typically, No. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN #include <disclaimer.h>

↪ replying to Phil Grace

Imran Hussain — Sun, 23 Jan 2000 15:04:04 GMT — source: Informix-list mailing list archive (1991-1998)

Hi, Do you have ODBC access to the ISAM files. If yes, then try WinSQL Professional at http://www.imranweb.com/freesoft Thanks, Phil Grace wrote: > Hi, > > I need to export data from an ISAM UNIX database into a flat file, so > that it can be imported in a new application. > > I know nothing about the platform it runs on or any version > information, but I was wondering if anyone had any advice or insight > into how easy or difficult this is going to be. > > Are we likely to find database tools at the customers that will enable > us to export the data ? > > TIA > Phil.

↪ replying to Phil Grace

asaric@my-deja.com — Sat, 29 Jan 2000 09:15:14 GMT — source: Informix-list mailing list archive (1991-1998)

Hi Phil, I am having the exact same problem. I just have an .DAT file that is ISAM format but have no idea how to flatten it. Did you get any leads since you posted the message? Thanks, Adi. In article <kf+GOACH+9Us9Fk3AEnBFXCzNlXP@4ax.com>, Phil Grace <phil@niche-cs.com> wrote: > Hi, > > I need to export data from an ISAM UNIX database into a flat file, so > that it can be imported in a new application. > > I know nothing about the platform it runs on or any version > information, but I was wondering if anyone had any advice or insight > into how easy or difficult this is going to be. > > Are we likely to find database tools at the customers that will enable > us to export the data ? > > TIA > Phil. > Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Phil Grace

asaric@my-deja.com — Sat, 29 Jan 2000 09:15:16 GMT — source: Informix-list mailing list archive (1991-1998)

Hi Phil, I am having the exact same problem. I just have an .DAT file that is ISAM format but have no idea how to flatten it. Did you get any leads since you posted the message? Thanks, Adi. In article <kf+GOACH+9Us9Fk3AEnBFXCzNlXP@4ax.com>, Phil Grace <phil@niche-cs.com> wrote: > Hi, > > I need to export data from an ISAM UNIX database into a flat file, so > that it can be imported in a new application. > > I know nothing about the platform it runs on or any version > information, but I was wondering if anyone had any advice or insight > into how easy or difficult this is going to be. > > Are we likely to find database tools at the customers that will enable > us to export the data ? > > TIA > Phil. > Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Imran Hussain

asaric@my-deja.com — Sat, 29 Jan 2000 09:17:32 GMT — source: Informix-list mailing list archive (1991-1998)

Hi Imran, I have the same problem as Phil and all I have is .DAT file that was FTPed over to NT box from UNIX. Is there any way to figure out the structure of the data and convert it into the ASCII format? Thanks, Adnan. In article <388B1897.60ED9501@imranweb.com>, Imran Hussain <imranh@imranweb.com> wrote: > Hi, > Do you have ODBC access to the ISAM files. If yes, then try WinSQL > Professional at http://www.imranweb.com/freesoft > > Thanks, > > Phil Grace wrote: > > > Hi, > > > > I need to export data from an ISAM UNIX database into a flat file, so > > that it can be imported in a new application. > > > > I know nothing about the platform it runs on or any version > > information, but I was wondering if anyone had any advice or insight > > into how easy or difficult this is going to be. > > > > Are we likely to find database tools at the customers that will enable > > us to export the data ? > > > > TIA > > Phil. > > Sent via Deja.com http://www.deja.com/ Before you buy.