quiz parallel linkage (Krikor Gullekian)
krikor Gullekian
krigul at yahoo.com
Thu Mar 5 11:51:59 CST 2015
Specify separately each linkage and you would avoid any issue, for example: ACC ACCOUNTS LINK ACCT_NUM TO CLIENT_NUM OF ACT_CLIENT OPT &
LINK ACCT_NUM TO CLIENT_NUM OF EXP_CLIENT OPT Krikor Gullekian
From: "powerh-l-request at lists.sowder.com" <powerh-l-request at lists.sowder.com>
To: powerh-l at lists.sowder.com
Sent: Thursday, March 5, 2015 11:31 AM
Subject: powerh-l Digest, Vol 113, Issue 11
Send powerh-l mailing list submissions to
powerh-l at lists.sowder.com
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
powerh-l-request at lists.sowder.com
You can reach the person managing the list at
powerh-l-owner at lists.sowder.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of powerh-l digest..."
Today's Topics:
1. RE:quiz parallel linkage (Pickering, John (NORBORD))
2. Re:quiz parallel linkage (Matt Ohmes)
----------------------------------------------------------------------
Message: 1
Date: Thu, 5 Mar 2015 15:25:53 +0000
From: "Pickering, John (NORBORD)" <John.Pickering at norbord.com>
Subject: RE: quiz parallel linkage
To: Lorry Litman <LLitman at manitoba-ehealth.ca>, PowerHouse listserver
<powerh-l at lists.sowder.com>
Message-ID:
<CO2PR0701MB74410D2E6B67FC66B387EA8961F0 at CO2PR0701MB744.namprd07.prod.outlook.com>
Content-Type: text/plain; charset="us-ascii"
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?
Try taking the explicit linkage out of the second side of the parallel linkage. As in:
ACC ACCOUNTS LINK ACCT_NUM &
TO CLIENT_NUM OF ACT_CLIENT OPT &
AND TO EXP_CLIENT OPT
This was Mary's suggestion and it solved my problem.
Regards,
JWP
From: powerh-l-bounces+john.pickering=norbord.com at lists.sowder.com [mailto:powerh-l-bounces+john.pickering=norbord.com at lists.sowder.com] On Behalf Of Lorry Litman
Sent: Thursday, March 05, 2015 9:56 AM
To: PowerHouse listserver
Subject: quiz parallel linkage
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<mailto:llitman at manitoba-ehealth.ca>
204-926-9076
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20150305/0a87f7bd/attachment-0001.htm>
------------------------------
Message: 2
Date: Thu, 5 Mar 2015 10:30:57 -0600
From: Matt Ohmes <mohmes at us.ibm.com>
Subject: Re: quiz parallel linkage
To: Lorry Litman <LLitman at manitoba-ehealth.ca>
Cc: PowerHouse listserver <powerh-l at lists.sowder.com>
Message-ID:
<OFE3CBB965.8D389A7A-ON86257DFF.00574F91-86257DFF.005ABAD5 at us.ibm.com>
Content-Type: text/plain; charset="utf-8"
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 <password>' 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.htm>
------------------------------
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" 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.
End of powerh-l Digest, Vol 113, Issue 11
*****************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20150305/bec0416a/attachment.htm>
More information about the powerh-l
mailing list