Expert: Concise Systems/Laird Scranton - 2/10/2007

Question
Hi,

I have A Phisical file defined with 2 Key fields.
First Keyfield is Clientnumber, second key Field is the first 2 positions of the field name (= 30 Positions):
Example :

R KLTEST                                               
 CLNTNO           8S 0       COLHDG('No')      
 NAME            30          COLHDG('Name')             
 Field3          30          COLHDG('tst')
K CLNTNO           
K NAME             2

How can I define this?

Thanks

Answer
You cannot index on a portion of a field, only on the full field. However, you could create the index on client number and full name, then in a program, move-left the first two characters of the name to the key field, set lower-limit on the file and read the next record.

- Laird