<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div dir="ltr" id="yui_3_16_0_1_1425577525050_6006">Specify separately each linkage and you would avoid any issue, for example:</div><div dir="ltr" id="yui_3_16_0_1_1425577525050_6005"> </div><div dir="ltr" id="yui_3_16_0_1_1425577525050_6003">ACC ACCOUNTS LINK ACCT_NUM TO CLIENT_NUM OF ACT_CLIENT OPT &<br> LINK ACCT_NUM TO CLIENT_NUM OF EXP_CLIENT OPT </div><div dir="ltr" id="yui_3_16_0_1_1425577525050_6024"> </div><div dir="ltr" id="yui_3_16_0_1_1425577525050_6025"> </div><div dir="ltr" id="yui_3_16_0_1_1425577525050_6038">Krikor Gullekian</div><br> <div style="font-family: HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_1_1425577525050_6035"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_1_1425577525050_6034"> <div dir="ltr" id="yui_3_16_0_1_1425577525050_6033"> <hr SIZE="1"> <font id="yui_3_16_0_1_1425577525050_6037" size="2" face="Arial"> <b><span style="font-weight: bold;">From:</span></b> "powerh-l-request@lists.sowder.com" <powerh-l-request@lists.sowder.com><br> <b><span style="font-weight: bold;">To:</span></b> powerh-l@lists.sowder.com <br> <b><span style="font-weight: bold;">Sent:</span></b> Thursday, March 5, 2015 11:31 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> powerh-l Digest, Vol 113, Issue 11<br> </font> </div> <div id="yui_3_16_0_1_1425577525050_6036" class="y_msg_container"><br>Send powerh-l mailing list submissions to<br> <a href="mailto:powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>or, via email, send a message with subject or body 'help' to<br> <a id="yui_3_16_0_1_1425577525050_6043" href="mailto:powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><br>You can reach the person managing the list at<br> <a id="yui_3_16_0_1_1425577525050_6044" href="mailto:powerh-l-owner@lists.sowder.com" ymailto="mailto:powerh-l-owner@lists.sowder.com">powerh-l-owner@lists.sowder.com</a><br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of powerh-l digest..."<br><br><br>Today's Topics:<br><br> 1. RE:quiz parallel linkage (Pickering, John (NORBORD))<br> 2. Re:quiz parallel linkage (Matt Ohmes)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Thu, 5 Mar 2015 15:25:53 +0000<br>From: "Pickering, John (NORBORD)" <<a href="mailto:John.Pickering@norbord.com" ymailto="mailto:John.Pickering@norbord.com">John.Pickering@norbord.com</a>><br>Subject: RE: quiz parallel linkage<br>To: Lorry Litman <<a href="mailto:LLitman@manitoba-ehealth.ca" ymailto="mailto:LLitman@manitoba-ehealth.ca">LLitman@manitoba-ehealth.ca</a>>, PowerHouse listserver<br> <<a href="mailto:powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>><br>Message-ID:<br> <<a href="mailto:CO2PR0701MB74410D2E6B67FC66B387EA8961F0@CO2PR0701MB744.namprd07.prod.outlook.com" ymailto="mailto:CO2PR0701MB74410D2E6B67FC66B387EA8961F0@CO2PR0701MB744.namprd07.prod.outlook.com">CO2PR0701MB74410D2E6B67FC66B387EA8961F0@CO2PR0701MB744.namprd07.prod.outlook.com</a>><br> <br>Content-Type: text/plain; charset="us-ascii"<br><br>I had a similar issue with parallel linkage. It was solved with a workaround for bug 401877 by Mary Pilgrim at Cognos. I'm running on an HP3000 but maybe the underlying code is the same?<br><br>Try taking the explicit linkage out of the second side of the parallel linkage. As in:<br>ACC ACCOUNTS LINK ACCT_NUM &<br>TO CLIENT_NUM OF ACT_CLIENT OPT &<br>AND TO EXP_CLIENT OPT<br><br>This was Mary's suggestion and it solved my problem.<br><br>Regards,<br>JWP<br><br>From: powerh-l-bounces+john.pickering=<a href="mailto:norbord.com@lists.sowder.com" ymailto="mailto:norbord.com@lists.sowder.com">norbord.com@lists.sowder.com</a> [mailto:powerh-l-bounces+john.pickering=<a href="mailto:norbord.com@lists.sowder.com" ymailto="mailto:norbord.com@lists.sowder.com">norbord.com@lists.sowder.com</a>] On Behalf Of Lorry Litman<br>Sent: Thursday, March 05, 2015 9:56 AM<br>To: PowerHouse listserver<br>Subject: quiz parallel linkage<br><br><br>Hi,<br><br>I'm not getting the results I'm expecting from this parallel linkage.<br>VMS 7.3-2 PH 7.10G1<br>This involves 3 RMS indexed files<br>Accounts, Act_client, Exp_client<br>Act_client and Exp_client are identical files/record structure.<br>Acct_num and client_num are both num * 9.<br>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.<br><br>ACC ACCOUNTS LINK ACCT_NUM &<br>TO CLIENT_NUM OF ACT_CLIENT OPT &<br>AND TO CLIENT_NUM OF EXP_CLIENT OPT<br><br>If the acct_num exists in act_client info is found/reported<br>If acct_num exists in exp_client info is not found/reported<br><br>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.<br><br>If I link to each file individually it will find it.<br><br>I've tried optional on the first linkage only, the second linkage only or both and no different result.<br><br>What am I not understanding of how parallel linkage should work?<br><br><br>Thanx<br>Lorry Litman<br>Application Management<br><a href="mailto:llitman@manitoba-ehealth.ca" ymailto="mailto:llitman@manitoba-ehealth.ca">llitman@manitoba-ehealth.ca</a><mailto:<a href="mailto:llitman@manitoba-ehealth.ca" ymailto="mailto:llitman@manitoba-ehealth.ca">llitman@manitoba-ehealth.ca</a>><br>204-926-9076<br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://lists.sowder.com/pipermail/powerh-l/attachments/20150305/0a87f7bd/attachment-0001.htm" target="_blank">http://lists.sowder.com/pipermail/powerh-l/attachments/20150305/0a87f7bd/attachment-0001.htm</a>><br><br>------------------------------<br><br>Message: 2<br>Date: Thu, 5 Mar 2015 10:30:57 -0600<br>From: Matt Ohmes <<a href="mailto:mohmes@us.ibm.com" ymailto="mailto:mohmes@us.ibm.com">mohmes@us.ibm.com</a>><br>Subject: Re: quiz parallel linkage<br>To: Lorry Litman <<a href="mailto:LLitman@manitoba-ehealth.ca" ymailto="mailto:LLitman@manitoba-ehealth.ca">LLitman@manitoba-ehealth.ca</a>><br>Cc: PowerHouse listserver <<a href="mailto:powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>><br>Message-ID:<br> <<a href="mailto:OFE3CBB965.8D389A7A-ON86257DFF.00574F91-86257DFF.005ABAD5@us.ibm.com" ymailto="mailto:OFE3CBB965.8D389A7A-ON86257DFF.00574F91-86257DFF.005ABAD5@us.ibm.com">OFE3CBB965.8D389A7A-ON86257DFF.00574F91-86257DFF.005ABAD5@us.ibm.com</a>><br>Content-Type: text/plain; charset="utf-8"<br><br>Hi Lorry, <br>First, bear with me if I get some syntax wrong. It's been about 10 years <br>since I've written any PowerHouse code. :-)<br><br>Parallel linkage can be confusing, but occasionally useful. It is <br>probably working as intended (barring some bug I don't know about) but not <br>as you expect. I'll follow up with another email with an example that <br>explains the difference, but let's attach your problem first.<br><br>You didn't include a report statement so I don't know how you are trying <br>to use the fact that you want to report one or the other, but let's try a <br>simple test to see if you are getting what you expect. <br><br>First, as others suggested, fully qualifying the Access statement is <br>always a good idea.<br><br>As a test, write a simple Report statement like this:<br>Report Acct_Num of Accounts Client_Num of Act_Client Client_Num of <br>Exp_Client<br><br>What you show see is something like this:<br>Acct_Num Client_Num Client_Num<br>1 1 (found on Act_Client only)<br>2 2 (found on Exp_Client only)<br>3 3 (found on Act_Client only)<br>4 4 4 (found on both files)<br>4 4 (2 records on first, only <br>1 on second)<br>5 (found on neither file)<br><br>Do you get something like that?<br><br>Two things to notice:<br>* Parallel linkage will read ALL parallel files AT THE SAME TIME (in <br>parallel) until ALL parallel files have run out of records for the key. <br>See Acct_Num 4 above.<br>* Putting Optional on ANY parallel file will make them all optional. In <br>the example above, you will see Account 5. If you leave Optional off all <br>parallel files, line 5 would not show up.<br><br>Hope that helps a bit. <br>Matt<br><br><br>From: Lorry Litman <<a href="mailto:LLitman@manitoba-ehealth.ca" ymailto="mailto:LLitman@manitoba-ehealth.ca">LLitman@manitoba-ehealth.ca</a>><br>To: PowerHouse listserver <<a href="mailto:powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>><br>Date: 03/05/2015 09:06 AM<br>Subject: quiz parallel linkage<br>Sent by: powerh-l-bounces+mohmes=<a href="mailto:us.ibm.com@lists.sowder.com" ymailto="mailto:us.ibm.com@lists.sowder.com">us.ibm.com@lists.sowder.com</a><br><br><br><br> <br>Hi,<br> <br>I?m not getting the results I?m expecting from this parallel linkage.<br>VMS 7.3-2 PH 7.10G1<br>This involves 3 RMS indexed files<br>Accounts, Act_client, Exp_client<br>Act_client and Exp_client are identical files/record structure.<br>Acct_num and client_num are both num * 9. <br>Acct_num should be found in one of act_client or exp_client. Yes, it?s <br>possible in rare situations it?s not found in either, but that?s a <br>different issue.<br> <br>ACC ACCOUNTS LINK ACCT_NUM &<br>TO CLIENT_NUM OF ACT_CLIENT OPT &<br>AND TO CLIENT_NUM OF EXP_CLIENT OPT<br> <br>If the acct_num exists in act_client info is found/reported<br>If acct_num exists in exp_client info is not found/reported<br> <br>If I reverse the access statement and have exp_client as the first link <br>and then act_client second I get the reverse result of the above.<br> <br>If I link to each file individually it will find it.<br> <br>I?ve tried optional on the first linkage only, the second linkage only or <br>both and no different result.<br> <br>What am I not understanding of how parallel linkage should work?<br> <br> <br>Thanx<br>Lorry Litman<br>Application Management<br><a href="mailto:llitman@manitoba-ehealth.ca" ymailto="mailto:llitman@manitoba-ehealth.ca">llitman@manitoba-ehealth.ca</a><br>204-926-9076<br> This email and/or any documents in this transmission is intended for the<br>addressee(s) only and may contain legally privileged or confidential <br>information. Any unauthorized use, disclosure, distribution, copying or <br>dissemination is strictly prohibited. If you receive this transmission in <br>error, please notify the sender immediately and return the original.<br>Ce courriel et tout document dans cette transmission est destin? ? la <br>personne ou aux personnes ? qui il est adress?. Il peut contenir des <br>informations privil?gi?es ou confidentielles. Toute utilisation, <br>divulgation, distribution, copie, ou diffusion non autoris?e est <br>strictement d?fendue. Si vous n'?tes pas le destinataire de ce message, <br>veuillez en informer l'exp?diteur imm?diatement et lui remettre <br>l'original.--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a href="mailto:powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Subscribe: 'subscribe' in message body to <br><a href="mailto:powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to <br><a href="mailto:powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><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 <br>list archive at Google.<br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://lists.sowder.com/pipermail/powerh-l/attachments/20150305/c8253517/attachment.htm" target="_blank">http://lists.sowder.com/pipermail/powerh-l/attachments/20150305/c8253517/attachment.htm</a>><br><br>------------------------------<br><br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a href="mailto:powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Subscribe: &quot;subscribe&quot; in message body to <a href="mailto:powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to <a href="mailto:powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><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.<br><br>End of powerh-l Digest, Vol 113, Issue 11<br>*****************************************<br><br><br></div> </div> </div> </div></body></html>