quiz parallel linkage

[Matt Ohmes]

Hi Lorry, 
First, bear with me if I get some syntax wrong. It's been about 10 years 
since I've written any PowerHouse code. :-)

Parallel linkage can be confusing, but occasionally useful.  It is 
probably working as intended (barring some bug I don't know about) but not 
as you expect.  I'll follow up with another email with an example that 
explains the difference, but let's attach your problem first.

You didn't include a report statement so I don't know how you are trying 
to use the fact that you want to report one or the other, but let's try a 
simple test to see if you are getting what you expect. 

First, as others suggested, fully qualifying the Access statement is 
always a good idea.

As a test, write a simple Report statement like this:
Report Acct_Num of Accounts  Client_Num of Act_Client  Client_Num of 
Exp_Client

What you show see is something like this:
Acct_Num        Client_Num      Client_Num
1               1                               (found on Act_Client only)
2                               2               (found on Exp_Client only)
3               3                               (found on Act_Client only)
4               4               4               (found on both files)
4               4                               (2 records on first, only 
1 on second)
5                                               (found on neither file)

Do you get something like that?

Two things to notice:
* Parallel linkage will read ALL parallel files AT THE SAME TIME (in 
parallel) until ALL parallel files have run out of records for the key. 
See Acct_Num 4 above.
* Putting Optional on ANY parallel file will make them all optional. In 
the example above, you will see Account 5. If you leave Optional off all 
parallel files, line 5 would not show up.

Hope that helps a bit. 
Matt


From:   Lorry Litman <LLitman at manitoba-ehealth.ca>
To:     PowerHouse listserver <powerh-l at lists.sowder.com>
Date:   03/05/2015 09:06 AM
Subject:        quiz parallel linkage
Sent by:        powerh-l-bounces+mohmes=us.ibm.com at lists.sowder.com



 
Hi,
 
I’m not getting the results I’m expecting from this parallel linkage.
VMS 7.3-2  PH 7.10G1
This involves 3 RMS indexed files
Accounts, Act_client, Exp_client
Act_client and Exp_client are identical files/record structure.
Acct_num and client_num are both num * 9. 
Acct_num should be found in one of act_client or exp_client. Yes, it’s 
possible in rare situations it’s not found in either, but that’s a 
different issue.
 
ACC ACCOUNTS LINK ACCT_NUM &
TO CLIENT_NUM OF ACT_CLIENT OPT &
AND TO CLIENT_NUM OF EXP_CLIENT OPT
 
If the acct_num exists in act_client info is found/reported
If acct_num exists in exp_client info is not found/reported
 
If I reverse the access statement and have exp_client as the first link 
and then act_client second I get the reverse result of the above.
 
If I link to each file individually it will find it.
 
I’ve tried optional on the first linkage only, the second linkage only or 
both and no different result.
 
What am I not understanding of how parallel linkage should work?
 
 
Thanx
Lorry Litman
Application Management
llitman at manitoba-ehealth.ca
204-926-9076
 This email and/or any documents in this transmission is intended for the
addressee(s) only and may contain legally privileged or confidential 
information.  Any unauthorized use, disclosure, distribution, copying or 
dissemination is strictly prohibited.  If you receive this transmission in 
error, please notify the sender immediately and return the original.
Ce courriel et tout document dans cette transmission est destiné à la 
personne ou aux personnes à qui il est adressé. Il peut contenir des 
informations privilégiées ou confidentielles. Toute utilisation, 
divulgation, distribution, copie, ou diffusion non autorisée est 
strictement défendue. Si vous n'êtes pas le destinataire de ce message, 
veuillez en informer l'expéditeur immédiatement et lui remettre 
l'original.--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to 
powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to 
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the 
list archive at Google.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20150305/c8253517/attachment-0001.htm>