James
As Craig observes, and as I wrote a little earlier, 010 <> 100
The old mistakes are the best!
Roy
Sent from my iPad
> On 14 Sep 2021, at 15:02, James B. Byrne <[log in to unmask]> wrote:
>
>
>
>> On Tue, September 14, 2021 09:39, Craig Lalley wrote:
>>
>> Maybe I am missing something obvious.
>> Search this page for “ CQ010876”The 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 *
> <empty.txt>
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|