× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.