Link to home
Start Free TrialLog in
Avatar of NetworkSolutions
NetworkSolutions

asked on

what are these files, IDA, IDX, DAT

I have a reallyy old AIX server, running a Database structure of the following Database file extensions
IDA
IDX
DAT
Has anyone seen this before? If so, what database structure is it? What Database is it running.
Is there a way to tell from the command line what database it is?
Avatar of jimmyb0004
jimmyb0004

.DAT files are DATA files not a database extension but used by systems..etc... atleast as far as I know.. check out these links..

http://filext.com/file-extension/DAT..... DATA

http://www.fileinfo.net/extension/idx.....description below...

Stores an index of files used by various programs; used by search functions to speed up searches; once a hard disk, directory of files, or database is indexed, the data can be searched and sorted more efficiently. Used by Microsoft FoxPro, Corel QuickFinder, ESRI ArcView, ICQ, and other programs.

http://filext.com/file-extension/IDA.... IIS Server File

seems like these tend to just tie to server files such as Apache or IIS for the most part. I don't think they are directed twords any database type.. atleast that I know of. Hope this helped.. check out the links I provided.
ASKER CERTIFIED SOLUTION
Avatar of Cyril Joudieh
Cyril Joudieh
Flag of Lebanon image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
IDX can still be ready by VFP 9.0. Some DAT files can be opened with VFP 9.0 as well.

In addition to what I wrote earlier, some text files that contain miscellaneous data are store in .dat files which are not true tables.
Probably Alpha Micro's ISAM PLUS
Probably MicroFocus COBOL ISAM files.
The DAT is the data file, IDX file contains the index data.

1) You can use MicroFocus compiler to create COBOL program to read data.
2) You can use MicroFocus "rebuild" tool to write the file out into 'Line Sequential' format.
3) You can read it directly, you do not need index files in this case.

Here is more detailed description of the same problem:
http://www.dbforums.com/showthread.php?threadid=477274
If the IDX/DAT files appear in pairs they could be Informix CISAM files.

http://www-306.ibm.com/software/data/informix/cisam/
Hmmmm... That combination of files makes it FoxPro can we agree? Because it seems some of the responses are selective of the extensions being picked up. The only case where all are used is FoxPro. I said that there were other variants of the database because I'm not sure if the dBase used exactly the same file components but at that time, it seems all databases/4GLs were sharing the file extensions... How nice it was. There was mild litigation. I wonder what reaction we'd get now if something similar happened as it was with dBase and FoxPro and ...