Re: How to view data in alphabetical order in a subfile

Hi.

The following will work:

When loading your subfile from the database, you are probably using a logical 
file(LF) with the name as key(or part of the key).

Move the value of the 'Position to' field to the key, and START the file(LF) 
NOT LESS than the key-value, and READ NEXT RECORD from there...

Do this every time you cange the 'Position to' field



Mvh.

Geir Kildal



-----Original Message-----
From: cobol400-l-bounces@xxxxxxxxxxxx
[mailto:cobol400-l-bounces@xxxxxxxxxxxx]On Behalf Of Bhat, Chandra
Sent: Friday, April 07, 2006 6:28 AM
To: cobol400-l@xxxxxxxxxxxx
Subject: [COBOL400-L] How to view data in alphabetical order in a
subfile


Folks,
 
In the below subfile, The records are displayed in the alphabetical order.
Now, what I want to know is how can I view records from a particular
customer name starting with alphabet say 'P' if when I enter P or PXXXXX in
the 'Position' to field?  
 
                                                   
                                                              Position to  .
. . . .              
 

 Type options, press Enter.

  2=Edit       3=Add     4=Delete                            
  
     Cust.Name     City                     A/c No

      A1                MUMBAI              10001

      A2                DELHI                  10002

      B1                HYDERABAD       20001

      B2                KOLKATA            20002

      C1                PUNE                  30001

      C2                CHENNAI             30002

      D1                BANGALORE       40001

      D2                NAGPUR              40002

      -                    -     
      -                    -    
 
Rgds
 
 
     
 
IMPORTANT NOTICE: 

The information in this email (and any attachments) is confidential. 
If you are not the intended recipient, you must not use or disseminate the
information.
If you have received this email in error, please immediately notify me by
"Reply" command 
and permanently delete the original and any copies or printouts thereof. 
Although this email and any attachments are believed to be free of any virus
or 
other defect that might affect any computer system into which it is received
and opened, 
it is the responsibility of the recipient to ensure that it is virus free
and no responsibility 
is accepted by American International Group, Inc. or its subsidiaries or
affiliates either 
jointly or severally, for any loss or damage arising in any way from its
use.