I'm still new to this, but from what I understand the "CHAIN" command will
only work with "keyed datasets" and only with "records with keyed values"
and selection by "keyed values". I'm not sure if your data-set "Mail-User"
is keyed. But again I've been using suprtool for only a few months, so it is
quite possible I'm wrong.




Jeff Roach, CNA, A+
Office Systems Administrator
InsectLore
[log in to unmask]





----- Original Message -----
From: "Jeff Mikolai" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Monday, November 13, 2000 1:02 PM
Subject: Chain vs. IF - No Results!


> 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