SCO Unix Server

[Richard Kreiss]

There is an easier solution to your question.

This will work for wither a clerk session or an output.

Select C- Index maintenance and build a demand index on the file in question.

Create a selection set with the first field (1) ge "4999" and the second field of the range (1) le "9999".  Save the selection set.  Build the index and then view the records selected in I-U-A in a browse using that demand index.  Adjust the browse to show the fields wanted.  If these are the records wanted, run your report using index 1 or use the selection set.  This involves no programming and allows you to select any range of values you want.

If you are running 5.8.02 or higher, you will have the ability to create a demand index with a selection set.

If the data is in more than one field, modify the map to create associated fields.  As an example if the values are in fields 1,2,3,4,5 prefix the filed name with a v1) filed name.  The in the selection set use the v1 instead of a field number.  FilePro will select all values between 4999 and 9999 no matter which field has the number.

That is a very good method of searching for phone numbers stored in multiple  fields in a file.  Associate the fields and build an index on the associated field.  The just enter the phone # in the index and you will be taken directly to that record.  As an aside, if there are three fields in the record, that record will appear 3 times in the index.  Therefore, indexes built on associated fields will be larger.


Richard Kreiss
GCC Consulting




> -----Original Message-----
> From: Filepro-list [mailto:filepro-list-
> bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Mike Schwartz
> via Filepro-list
> Sent: Wednesday, August 22, 2018 11:19 AM
> To: 'Filepro List' <filepro-list at celestial.com>
> Cc: Mike Schwartz <filepromike at gmail.com>
> Subject: RE: SCO Unix Server
> 
> > Having Wyse serial terminals does make it a little more complicated,
> > but it is doable.  When we started running filePro in a VM we used a
> > serial port concentrator from Digi that our virtual Linux server
> > connected to over the network and then the serial cables ran from the
> > Digi device to the Wyse serial terminals.
> 
>      Also look at Comtrol serial port boxes.  I don't know if they still support SCO
> Unix, but their sales department should be able to tell you that.
> 
> Mike Schwartz
> 
> 
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/mailman/listinfo/filepro-list