RE: Indexing a flat file

["Andy Renk" <acr12345@xxxxxxxxxxxxxxxxx>]

If you have the TAA tools you might want to check out the SRCARC tool.  It has a  Scan Source Archive - SCNSRCARC command once you have archived your source code with the tool.

Andy Renk

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jerry Adams
Sent: Friday, July 27, 2007 11:47 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Indexing a flat file

Since you have OCL36 members, you probably have BLDINDEX.  In the 36 
environment it creates what's called an alternate index.  It can be used 
to access a file just like a logical (which, in fact, it is on the 
System i).  The major limitation is that it has a limit of three [3] 
start-stop positions for contiguous key fields. 

Not very modern (at all), but it does work on flat files and is quick.  
Once built new entries in the table show up without any intervention.


	* Jerry C. Adams
*IBM System i Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
	615.995.7024
fax
	615.995.1201
email
	jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Pascal Bellerose wrote:
> Hi,
>  
> I'm looking for a utility that would index a file having a few field
> and escpecially one that contains all sorts of data and needs several
> formats to read it depending on another field's value.
>  
> In fact, to tell you everything, we have a huge file containing all our
> source code from every program we have.
> We use this file to lookup some variables or fields usage in our
> programs.  
> This is necessary to avoid time consuming searches with PDM and because
> we still have some old OCL36 procedures (yes we still have those "state
> of the art" oldies...)
>  
> So our problem is that this file is so huge that a SELECT LIKE request
> takes about 5 minutes for each request.  To make subselects is simply
> out of the picture right now.
>  
> So we are looking for a tool that would index the SRCDTA field from our
> megafile and build a file that let's us easily lookup any value that
> would appear in our source code.
>  
> The file has 13 million records and it keeps growing.
>  
> Or, if anybody has another way to lookup source code without having to
> use Hawkeye or PDM, and that would not take forever to load, just let me
> know.
>  
> Thanks guys,  and keep the good work!!!
>  
>  
>  
>
> Pascal Bellerose
> pascal_bellerose@xxxxxxxxxxxx 
> Réseau/Network: 2114
>  
>
> Cascades Canada inc.
> 412, Boul. Marie-Victorin
> Kingsey-Falls, PQ, Canada
> J0A 1B0
> Équipe de support TI Corporatif / Corporate IT Support team
> Tél./Phone: 819-363-6100
> Fax/Télécopie: 819-363-6155
>  
> Pour toute demande de support: Cliquez ici  (
> http://ti.zonec.cascades.com/documents/Procédures%20générales/SUP-00002F.doc
> )
> For all support requests:  Click here (
> http://ti.zonec.cascades.com/documents/Procédures%20générales/SUP-00002E.doc
> )
>  
> Pour toutes correspondances en rapport avec un appel de support, svp
> veuillez spécifier votre numéro d'appel dans le sujet de votre message
>  
> For all communications concerning a support call, please mention the
> call number in the subject of your emails.
>