Check out the following. When I do the chained read in Suprtool I get no
entries returned but with the IF I do. I have reindexed this entire database
with no luck. Any suggestions or ideas?

SUPRTOOL/iX/Copyright Robelle Consulting Ltd. 1981-2000.  Type H for help.
(Version 4.3 VAR)  MON, NOV 13, 2000, 11:16 AM
Licensee:  Smith-Gardner Ecometry Customer Use Only
Today's Hint. For MPE files, List Standard is equivalent to List Octal,Char.
>BA AUXMCS,1,DOALL
>FO SETS

Database: AUXMCS.CCDATA.SGAII  TPI: Omnidex 3.04.64

                      Set       Item             Entry    Load   Entry
Sets:                 Num Type  Count  Capacity  Count    Factor Length  B/F
   AUX-CTL-MAST       1   M     3      100003    3334     3  %   40      11
   AUX-CUST-MAST      2   A     1      500000    46456    9  %   5       31
   AUX-EDP-MAST       3   A     1      500000    46450    9  %   2       39
   AUX-OPER-MAST      4   A     1      500000    769      0  %   4       25
   CATEGORY-MAST      5   M     3      5000      0        0  %   31      14
   TEMPLATE-MAST      6   A     1      15000     1956     13 %   6       30
   ENTRYOPK-DETAIL    7   D     14     500000    47068    9  %   35      8
   TEMPLATE-DTL       8   D     9      15002     1956     13 %   35      13
   AUX-ITEM-EDP       9   A     1      65000     0        0  %   2       39
   TEMPLATE-INFO      10  D     3      65000     0        0  %   328     1
   DATE-SHIPPED-A     11  A     1      2003      703      35 %   4       25
   FULL-ORDER-NO-A    12  A     1      1154927   762147   66 %   6       30
   ENTRY-OPER-A       13  A     1      2003      147      7  %   4       25
   EDPNO-A            14  A     1      69752     25452    36 %   2       20
   SERIALNO-A         15  A     1      1546873   1030124  67 %   15      19
   SR-NOS-SHIPPED     16  D     6      1731107   1149907  66 %   34      7
   CUST-EDP-A         17  A     1      633165    379899   60 %   2       39
   MACS-LEADS         18  D     30     633168    379899   60 %   89      4
   USERID             19  A     1      5003      0        0  %   4       14
   MAIL-USER          20  D     3      150000    14275    10 %   34      15
   AVG-COST           21  D     3      1500003   700267   47 %   10      9
   TRANSMITTAL-MAST   22  A     1      700027    3        0  %   4       25
   BUCKET-FR          23  A     1      503       2        0  %   1       21
   PTB-RULESET        24  D     15     507       24       5  %   35      13
   ALERT-ADDRESSES    25  M     1      409       11       3  %   16      6
   EDPNO-K            26  A     1      500       5        1  %   2       39
   EDPNO-R            27  A     1      500       0        0  %   2       39
   EDI-KIT-INDEX      28  D     3      504       7        1  %   14      7
   EDI-RESEND         29  D     4      504       0        0  %   14      7
   EDI-ORDER-SEQ      30  M     2      503       0        0  %   7       21
   OAINVOICES         31  D     10     700030    2211     0  %   34      10
>FO MAIL-USER

Database: AUXMCS.CCDATA.SGAII  TPI: Omnidex 3.04.64

    MAIL-USER        Detail                  Set# 20
       Entry:                     Offset
          USER-ID              X8      1  <<TPI>>
          USER-NAME            X20     9  <<TPI>>
          EMAIL-ADDR           X40    29  <<TPI>>
    Capacity: 150000 (15)  Entries: 14275  Highwater: 14275  Bytes: 68
>CHAIN MAIL-USER,USER-ID="ISMS4066"
>L S
>X
Warning:  Using DBGET for the input records
IN=0, OUT=0. CPU-Sec=1. Wall-Sec=1.

>GET MAIL-USER
>IF USER-ID="ISMS4066"
>L S
>X
Nov 13, 2000 11:16          Base AUXMCS Set MAIL-USER                Page 1


USER-ID  USER-NAME            EMAIL-ADDR

ISMS4066 MAYA STEIN      5128  [log in to unmask]
ISMS4066 MAYA STEIN      5128  [log in to unmask]
IN=14275, OUT=2. CPU-Sec=1. Wall-Sec=1.

>EXIT

END OF PROGRAM