can we search a flat file?

mf_user · New User Joined: 05 Jan 2006 Posts: 47

Hi,

We get some data from a GSAM file and we need to use certain information from this file to search a flat file and write out the records.

Is it possible to search the flat file without loading it into any internal array or table?

I am not able to make it out.

Craq Giegerich · Posted: Thu Mar 06, 2008 8:57 pm

Not in any reasonable fashion.

Devzee · Posted: Thu Mar 06, 2008 11:08 pm

If I understand your question correctly - what you wanted to do is compare GSAM file (based on few fields/records) with another file.

Is this correct? If so then you can do this using SORT.

earsha · New User Joined: 16 Mar 2007 Posts: 17 Location: Pune

yes sort will be a better option for this

mf_user · New User Joined: 05 Jan 2006 Posts: 47

Thank you.

Would you please put some examples here.

TIA.

raak · Posted: Thu Mar 13, 2008 12:52 pm

If it is just to match the records from both the files and write the matched records from any file to the output, U can use SORT.

If u r using Syncsort, U can use the JOINKEYS option to do this..

the_gautam · Posted: Mon Mar 17, 2008 6:58 am

however, if your requirement is to search the flat file. you may opt for loading the flat file into a working storage table (ofcourse iff the size of the file is not that large) to get it searched on the table.

jasorn · Active User Joined: 12 Jul 2006 Posts: 191 Location: USA

DFSORT allows substring searches which search whole records for strings. I have a cobol program I use too in case I want to search multiple datasets. It's pretty fast enough for my needs.

CICS Guy · Posted: Thu Apr 10, 2008 7:53 am