Unix/Linux Go Back    


Shell Programming and Scripting BSD, Linux, and UNIX shell scripting — Post awk, bash, csh, ksh, perl, php, python, sed, sh, shell scripts, and other shell scripting languages questions here.

How to extract data from indexed files (ISAM files) maintained in an unix server.

Shell Programming and Scripting


Closed    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 12-10-2010   -   Original Discussion by devina
devina's Unix or Linux Image
devina devina is offline
Registered User
 
Join Date: Dec 2010
Last Activity: 27 September 2011, 5:20 AM EDT
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
How to extract data from indexed files (ISAM files) maintained in an unix server.

Hi,

Could someone please assist on a quick way of How to extract data from indexed files (ISAM files) maintained in an UNIX(AIX) server.The file data needs to be extracted in flat text file or CSV or excel format .

Usually we have programs in microfocus COBOL to extract data, but would like to find an alternate option.

Thanks!
Sponsored Links
    #2  
Old Unix and Linux 12-10-2010   -   Original Discussion by devina
vbe's Unix or Linux Image
vbe vbe is offline Forum Staff  
Moderator
 
Join Date: Sep 2005
Last Activity: 12 December 2017, 7:09 AM EST
Location: Switzerland - GE
Posts: 6,491
Thanks: 296
Thanked 555 Times in 517 Posts
There is no quick way to read/extract a ISAM file, you mention it: Usually used for COBOL but also PASCAL and C... Are you talking of full ISAM database files?

---------- Post updated at 15:08 ---------- Previous update was at 15:07 ----------

I suppose if you have SAS it should be easy...

---------- Post updated at 15:17 ---------- Previous update was at 15:08 ----------

7.4 Random Access Files
The Following User Says Thank You to vbe For This Useful Post:
devina (12-12-2010)
Sponsored Links
    #3  
Old Unix and Linux 12-12-2010   -   Original Discussion by devina
devina's Unix or Linux Image
devina devina is offline
Registered User
 
Join Date: Dec 2010
Last Activity: 27 September 2011, 5:20 AM EDT
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
Yes they are fully ISAM files. There is one option of using Relativity coupled on an ODBC driver. However this is not working for for huge files with lot of data. Also some of the variables which are defined as COMP variables in the field definition are extracted as blank when using Relativility Cleint.
Sponsored Links
Closed

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
AWK, extract data from multiple files Liverpaul09 UNIX for Dummies Questions & Answers 8 09-29-2010 09:43 AM
extract the relevant data files for a quarter w020637 Shell Programming and Scripting 7 02-13-2009 03:37 PM
Perl script for extract data from xml files allways4u21 Shell Programming and Scripting 3 01-15-2009 06:54 AM
How can i move data files from a server to unix folder shah2 Shell Programming and Scripting 1 03-01-2004 06:38 PM
indexed sequential access in c files vrkiruba Programming 0 05-23-2001 04:42 AM



All times are GMT -4. The time now is 12:01 PM.