Right,
I don't see the regular Image indexes for the set, though all appear to be
indexed by OmniDex or whatnot.
What fields in this set are indexed (chained) to an Image master set?
> -----Original Message-----
> From: Jeff Roach [mailto:[log in to unmask]]
> Sent: Monday, November 13, 2000 2:27 PM
> To: [log in to unmask]
> Subject: Re: Chain vs. IF - No Results!
>
>
> 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
>
|