×
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.
An alternative to Peter's suggestion would be, if you have a spare 500MB of
disk space, to create a single reference file with every possible catalogue
number in. You could then use SQL to pull out records from the reference
file that don't have a match in your catalogue file.
It's not neat by any standards though...
Hope it helps
Jonathan
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of David Foxwell
Sent: 03 October 2007 10:31
To: rpg400-l@xxxxxxxxxxxx
Subject: Extraction problem
Hi,
I have a file with catalogue numbers like this : AA00001 to ZZ99999.
Is there a neat way to extract all the numbers available ( not being used )
for a given prefix ?
eg, the list of numbers available between PE00020 and PF99290, list of
numbers with prefix AZ.
Thanks
As an Amazon Associate we earn from qualifying purchases.
This thread ...
Re: Debugging RPGIV program used by SQL UDF (was Extraction problem), (continued)
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.
midrange.com
