Who's On?

	Membership:
	Latest: Zac Shields
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5211

	People Online:
	Visitors: 320
	Members: 0
	Total: 320

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

informix DB

3 Replies

0 Subscribed to this topic

27 Subscribed to this forum

Sort:

Author

Messages

TJ Mann

Veteran Member

Posts: 70

11/14/2014 1:09 PM

we have old old informix DB which we need to see if we can extract data into CSV format. does anyone have any informix DB experience here ? i just to see if i can login and extract data into .csv format.

John Henley

Posts: 3353

11/14/2014 1:30 PM

What version? You should be able to get an ODBC/OLE DB provider hooked up to it.

TJ Mann

Veteran Member

Posts: 70

11/14/2014 1:38 PM

we don't even know how to login to informix. all i know for now, it resides under AIX box.

so i will need username/passwd/servername in order to get some sort of info from there ?

i believe, 15 years ago, lawson was ran under informix.

John Henley

Posts: 3353

11/14/2014 2:05 PM

Wow, you're taking me way back in time...
Do you know if the Informix software is installed?
When informix is installed it should have an env variable $INFORMIXDIR pointing to the installed location (/usr/informix by default).
Under $INFORMIXDIR/etc/ there are "onconfig" files that will help you determine the configuration.

If you can find that you might be lucky...

As for the database, there were a number of ways to store Informix data, from raw disk to container files, etc....what do you see for your old database?