<font size=2 face="sans-serif">Hi Lorry, </font>
<br><font size=2 face="sans-serif">First, bear with me if I get some syntax
wrong. It's been about 10 years since I've written any PowerHouse code.
:-)</font>
<br>
<br><font size=2 face="sans-serif">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.</font>
<br>
<br><font size=2 face="sans-serif">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. </font>
<br>
<br><font size=2 face="sans-serif">First, as others suggested, fully qualifying
the Access statement is always a good idea.</font>
<br>
<br><font size=2 face="sans-serif">As a test, write a simple Report statement
like this:</font>
<br><font size=2 face="sans-serif">Report Acct_Num of Accounts Client_Num
of Act_Client Client_Num of Exp_Client</font>
<br>
<br><font size=2 face="sans-serif">What you show see is something like
this:</font>
<br><font size=2 face="sans-serif">Acct_Num Client_Num
Client_Num</font>
<br><font size=2 face="sans-serif">1
1
(found on Act_Client only)</font>
<br><font size=2 face="sans-serif">2
2
(found on Exp_Client only)</font>
<br><font size=2 face="sans-serif">3
3
(found on Act_Client only)</font>
<br><font size=2 face="sans-serif">4
4
4
(found on both files)</font>
<br><font size=2 face="sans-serif">4
4
<b>(2 records on first, only 1 on second)</b></font>
<br><font size=2 face="sans-serif">5
(found on neither file)</font>
<br>
<br><font size=2 face="sans-serif">Do you get something like that?</font>
<br>
<br><font size=2 face="sans-serif">Two things to notice:</font>
<br><font size=2 face="sans-serif">* 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.</font>
<br><font size=2 face="sans-serif">* 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.</font>
<br>
<br><font size=2 face="sans-serif">Hope that helps a bit. </font>
<br><font size=2 face="sans-serif">Matt</font>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From:
</font><font size=1 face="sans-serif">Lorry Litman <LLitman@manitoba-ehealth.ca></font>
<br><font size=1 color=#5f5f5f face="sans-serif">To:
</font><font size=1 face="sans-serif">PowerHouse listserver
<powerh-l@lists.sowder.com></font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date:
</font><font size=1 face="sans-serif">03/05/2015 09:06 AM</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject:
</font><font size=1 face="sans-serif">quiz parallel
linkage</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Sent by:
</font><font size=1 face="sans-serif">powerh-l-bounces+mohmes=us.ibm.com@lists.sowder.com</font>
<br>
<hr noshade>
<br>
<br>
<br><font size=3 face="Garamond"> </font>
<br><font size=3 face="Garamond">Hi,</font>
<br><font size=3 face="Garamond"> </font>
<br><font size=3 face="Garamond">I’m not getting the results I’m expecting
from this parallel linkage.</font>
<br><font size=3 face="Garamond">VMS 7.3-2 PH 7.10G1</font>
<br><font size=3 face="Garamond">This involves 3 RMS indexed files</font>
<br><font size=3 face="Garamond">Accounts, Act_client, Exp_client</font>
<br><font size=3 face="Garamond">Act_client and Exp_client are identical
files/record structure.</font>
<br><font size=3 face="Garamond">Acct_num and client_num are both num *
9. </font>
<br><font size=3 face="Garamond">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.</font>
<br><font size=3 face="Garamond"> </font>
<br><font size=3 face="Garamond">ACC ACCOUNTS LINK ACCT_NUM &</font>
<br><font size=3 face="Garamond">TO CLIENT_NUM OF ACT_CLIENT OPT &</font>
<br><font size=3 face="Garamond">AND TO CLIENT_NUM OF EXP_CLIENT OPT</font>
<br><font size=3 face="Garamond"> </font>
<br><font size=3 face="Garamond">If the acct_num exists in act_client info
is found/reported</font>
<br><font size=3 face="Garamond">If acct_num exists in exp_client info
is not found/reported</font>
<br><font size=3 face="Garamond"> </font>
<br><font size=3 face="Garamond">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.</font>
<br><font size=3 face="Garamond"> </font>
<br><font size=3 face="Garamond">If I link to each file individually it
will find it.</font>
<br><font size=3 face="Garamond"> </font>
<br><font size=3 face="Garamond">I’ve tried optional on the first linkage
only, the second linkage only or both and no different result.</font>
<br><font size=3 face="Garamond"> </font>
<br><font size=3 face="Garamond">What am I not understanding of how parallel
linkage should work?</font>
<br><font size=3 face="Garamond"> </font>
<br><font size=3 face="Garamond"> </font>
<br><font size=3 face="Garamond">Thanx</font>
<br><font size=3 face="Garamond">Lorry Litman</font>
<br><font size=3 face="Garamond">Application Management</font>
<br><a href="mailto:llitman@manitoba-ehealth.ca"><font size=3 color=blue face="Garamond"><u>llitman@manitoba-ehealth.ca</u></font></a>
<br><font size=3 face="Garamond">204-926-9076</font>
<br><font size=2 face="Calibri"> </font><font size=3>This email and/or
any documents in this transmission is intended for the<br>
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.</font>
<p><font size=3>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.</font><tt><font size=2>--<br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>
Mailing list: powerh-l@lists.sowder.com<br>
Subscribe: 'subscribe' in message body to powerh-l-request@lists.sowder.com<br>
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to
powerh-l-request@lists.sowder.com<br>
</font></tt><a href="http://lists.sowder.com/mailman/listinfo/powerh-l"><tt><font size=2>http://lists.sowder.com/mailman/listinfo/powerh-l</font></tt></a><tt><font size=2><br>
This list is closed, thus to post to the list you must be a subscriber.<br>
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.</font></tt>
<p>