My problem was me. Dyslexia had me transposing two digits at random times.
On Tue, September 14, 2021 10:16, Francois Desrochers wrote:
> James,
>
> What's the definition of TRANS-IDENT? You are searching for a specific value.
Can there be some invisible garbage character in that field which would
prevent an exact match? Can you do a "wildcard" search on parts of the key
value? Can you extract the record found for account 100000 and dump it in
hexadecimal? Enabling DISPLAY FUNCTIONS in Reflection may be enough.
>
> Thanks...François
>
> -----Original Message-----
> From: HP-3000 Systems Discussion <[log in to unmask]> On Behalf Of James
B. Byrne
> Sent: Tuesday, September 14, 2021 10:02 AM
> To: [log in to unmask]
> Subject: Re: [HP3000-L] ***Spam***Re: [EXT]: dangling detail
>
> Caution: This email originates from outside of Fresche | Attention: Ce
message provient de l'extérieur de Fresche
>
>
> On Tue, September 14, 2021 09:39, Craig Lalley wrote:
>>
>> Maybe I am missing something obvious. Search this page for âEURoeÂ
CQ010876âEURThe bottom is CQ100876 -Craig
>>
>
> Set 23: TRANACCT, Detail (Primary Path is marked "!") Global
> Average
> Detail Master Detail Detail
Chain Path to Master set SearchField SearchField SortField
Length
>
> 1!ACCOUNTS ACCOUNT-NUMBER ACCOUNT-NUMBER
61.8 2 TRANSACTIONS TRANS-IDENT TRANS-IDENT
1.0 3 DATE-CTRL DATE DATE-TRANSACTED
65.2
>
> There is no entry in the TRANSACTIONS master for "CQ010876". However, I can
find an entry in TRANACCT for this value by chaining down the ACCOUNT-NUMBER
path.
>
> I can find a TRANACCT entry for TRANS-IDENT CQ01876 only by chaining the data
set using the ACCOUNT-NUMBER path. A sequential search of the dataset
selecting on that value for TRANS-IDENT fails to return anything. Likewise,
accessing the dataset using the key value CQ010876 does not return anything.
>
> However, there is an entry in that dataset for CQ010876 as evidenced by the
return for ACCOUNT-NUMBER 100000.
>
> So, what is wrong with the dataset? I can understand a broken chain. But
why does a sequential search not find the entry anyway?
>
> Also, Adager does not report any errors:
> PathExamine:
> ACCTDB.DATA.HARTLYNE. Dataset [NO MORE] ? TRANACCT
>
> Please specify the path that you want to examine.
>
> Set 23: TRANACCT, Detail (Primary Path is marked "!") Global
> Average
> Detail Master Detail Detail
Chain Path to Master set SearchField SearchField SortField
Length
>
> 1!ACCOUNTS ACCOUNT-NUMBER ACCOUNT-NUMBER
61.8 2 TRANSACTIONS TRANS-IDENT TRANS-IDENT
1.0 3 DATE-CTRL DATE DATE-TRANSACTED
65.2
>
> Define a path using a DETAIL SearchField ^
>
> DETAIL SearchField name [NO MORE] ? TRANS-IDENT
>
> Detail TRANACCT. Capacity: 677803, entries: 610460
> Associated master TRANSACTIONS. Capacity: 653927, entries: 611713
>
> Adager's native-mode PathExamine
>
> Phase 1/4 0% complete CPU time: 0:00'00 Elapsed time: 0:00'00
> complete 0:01'02 0:01'52
> Phase 2/4 0% complete CPU time: 0:00'00 Elapsed time: 0:00'00
> complete 0:00'27 0:00'48
> Phase 3/4 0% complete CPU time: 0:00'00 Elapsed time: 0:00'00
> complete 0:01'56 0:02'25
> Phase 4/4 0% complete CPU time: 0:00'00 Elapsed time: 0:00'00
> complete 0:00'25 0:00'26
> Total Elapsed time: 0:05'31
>
> --------------------------------------------------------------------- I did
not detect any errors in detail dataset TRANACCT
> (detail SearchField TRANS-IDENT to manual master TRANSACTIONS)
> ---------------------------------------------------------------------
>
>
>
>
>
> --
> *** e-Mail is NOT a SECURE channel ***
> Do NOT transmit sensitive data via e-Mail
> Unencrypted messages have no legal claim to privacy
> Do NOT open attachments nor follow links sent by e-Mail
>
> James B. Byrne mailto:[log in to unmask]
> Harte & Lyne Limited http://www.harte-lyne.ca
> 9 Brockley Drive vox: +1 905 561 1241
> Hamilton, Ontario fax: +1 905 561 0757
> Canada L8E 3C3
>
> * To join/leave the list, search archives, change list settings, * * etc.,
please visit http://raven.utc.edu/archives/hp3000-l.html * Confidentiality
Warning/Avertissement de confidentialité:
>
> This message is intended only for the named recipients. This message may
contain information that is privileged or confidential. If you are not the
named recipient, its employee or its agent, please notify us immediately and
permanently destroy this message and any copies you may have. Ce message est
destiné uniquement aux destinataires dûment nommés. Il peut contenir de
l'information privilégiée ou confidentielle. Si vous n'êtes pas le
destinataire dûment nommé, son employé ou son mandataire, veuillez nous
aviser sans tarder et supprimer ce message ainsi que toute copie qui peut en
avoir été faite.
>
--
*** e-Mail is NOT a SECURE channel ***
Do NOT transmit sensitive data via e-Mail
Unencrypted messages have no legal claim to privacy
Do NOT open attachments nor follow links sent by e-Mail
James B. Byrne mailto:[log in to unmask]
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
--
*** e-Mail is NOT a SECURE channel ***
Do NOT transmit sensitive data via e-Mail
Unencrypted messages have no legal claim to privacy
Do NOT open attachments nor follow links sent by e-Mail
James B. Byrne mailto:[log in to unmask]
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|