Isn't the correct syntax "LINK VIAINDEX ..."<br><br>Wayne<br><br><div><span class="gmail_quote">On 4/10/06, <b class="gmail_sendername">Tracy Johnson</b> <<a href="mailto:vzeo5z3y@verizon.net">vzeo5z3y@verizon.net
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I suppose it is time to call support for new tapes... I bet my 2004 unopened
8.49D tapes won't do.<br><br>(They still make tapes don't they?)<br><br>>From: "Deskin, Bob" <<a href="mailto:Bob.Deskin@Cognos.COM">Bob.Deskin@Cognos.COM</a>><br>>Date: Mon Apr 10 09:09:33 CDT 2006<br>
>To: <a href="mailto:tmjva@verizon.net">tmjva@verizon.net</a>, <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>>Subject: RE: RE: RE: RE: RE: Linking two Indexed Subfiles (HP)<br><br>>I finally found a version of
8.19C3 to try this on. It's a bug in 8.19<br>>that has been fixed. It no longer occurs in 8.49D1.<br>><br>>Regards<br>><br>>Bob<br>><br>>-----Original Message-----<br>>From: powerh-l-bounces+bob.deskin=
<a href="mailto:cognos.com@lists.sowder.com">cognos.com@lists.sowder.com</a><br>>[mailto:<a href="mailto:powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com">powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com</a>
] On<br>>Behalf Of Tracy Johnson<br>>Sent: April 7, 2006 3:49 PM<br>>To: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>>Subject: Re: RE: RE: RE: RE: Linking two Indexed Subfiles (HP)
<br>><br>><br>>I made the change, it works one way but not the other. User is logged<br>>into the group and account that HMCTABL is in. Two access statements<br>>below. (GO statements removed.)<br>><br>
>Q U I Z (PowerHouse 8.19.C3)<br>>Copyright 1998 COGNOS INCORPORATED<br>>LUCAS CONTROL SYSTEMS PRODUCTS<br>><br>>> USE MYCTABL.QUIZ LIST<br>>> ACC *JLCTABL.PUB45.JL LINK JL-CC OF JLCTABL TO HA-CC OF *HMCTABL
<br>>*W* PowerHouse name for JLCTABL.PUB45.JL is JLCTABL.<br>>> REPORT ALL<br>>> SET REP SPACING 1<br>>> SET REPORT LIMIT 2222<br>>> ACC *HMCTABL LINK HA-CC OF HMCTABL TO JL-CC OF *JLCTABL.PUB45.JL
<br>>*W* PowerHouse name for JLCTABL.PUB45.JL is JLCTABL.<br>>*E* Can't find the item JL-CC OF JLCTABL.PUB45.JL.<br>>> REPORT ALL<br>>> SET REP SPACING 1<br>>> SET REPORT LIMIT 2222<br>><br>>QSHOW follows:
<br>><br>>- SHOW SUBFILE HMCTABL<br>>06/04/07 SUBFILE DICTIONARY Page<br>>1<br>> SUBFILE RECORD REPORT<br>><br>><br>> Subfile: HMCTABL
<br>> Type: Permanent<br>> Organization: Indexed<br>> Format: 8<br>> Record Size: 38 Bytes<br>><br>> Item Type Offset Size
<br>>Occurs<br>><br>> HA-CC IEEE FLOAT 0 8<br>> CHEADER CHARACTER 8 30<br>><br>>-- Index Contents --<br>><br>> ** HA-CC is a 8 byte REPEATING PRIMARY index **
<br>><br>><br>> Segment Type Size Ord<br>>Offset<br>> HA-CC IEEE FLOAT 8 A<br>>0<br>><br>> ?<br>><br>>- SHOW SUBFILE JLCTABL
<br>>06/04/07 SUBFILE DICTIONARY Page<br>>1<br>> SUBFILE RECORD REPORT<br>><br>><br>> Subfile: JLCTABL<br>> Type: Permanent
<br>> Organization: Indexed<br>> Format: 8<br>> Record Size: 38 Bytes<br>><br>> Item Type Offset Size<br>>Occurs<br>><br>> JL-CC IEEE FLOAT 0 8
<br>> CHEADER CHARACTER 8 30<br>><br>>-- Index Contents --<br>><br>> ** JL-CC is a 8 byte REPEATING PRIMARY index **<br>><br>><br>> Segment Type Size Ord
<br>>Offset<br>> JL-CC IEEE FLOAT 8 A<br>>0<br>><br>> ?<br>><br>>-<br>><br>><br>>>From: "Deskin, Bob" <<a href="mailto:Bob.Deskin@Cognos.COM">
Bob.Deskin@Cognos.COM</a>><br>>>Date: Fri Apr 07 13:56:42 CDT 2006<br>>>To: <a href="mailto:tmjva@verizon.net">tmjva@verizon.net</a>, <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>
<br>>>Subject: RE: RE: RE: RE: Linking two Indexed Subfiles (HP)<br>><br>>>Have you tried qualifying JL-CC as in<br>>><br>>>ACC *JLCTABL.PUB45.JL LINK JL-CC OF JCLTABL TO HA-CC OF *HMCTABL<br>>>
<br>>>And if you do a SHOW SUBFILE in QSHOW, does JL-CC exist?<br>>><br>>>Bob<br>>><br>>>-----Original Message-----<br>>>From: powerh-l-bounces+bob.deskin=<a href="mailto:cognos.com@lists.sowder.com">
cognos.com@lists.sowder.com</a><br>>>[mailto:<a href="mailto:powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com">powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com</a>] On<br>>>Behalf Of Tracy Johnson
<br>>>Sent: April 7, 2006 11:52 AM<br>>>To: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>>>Subject: Re: RE: RE: RE: Linking two Indexed Subfiles (HP)<br>>><br>>>
<br>>>Sorry I retyped it instead of cutting and pasting. The corrected<br>>>message below is:<br>>><br>>>>> ACC *JLCTABL.PUB45.JL LINK JL-CC TO HA-CC OF *HMCTABL<br>>>>*W* PowerHouse name for
HMCTABL.PUBAS.MMV090 is HMCTABL.<br>>>>*W* PowerHouse name for JLCTABL.PUB45 is JLCTABL.<br>>>>*E* Can't find the item JL-CC of JLCTABL.PUB45.JL.<br>>><br>>>I still have unopened tapes for 8.49D
sitting on my desk since 2004.<br>>>Haven't upgraded since it is not done lightly with several hundred<br>>>users and our programming staff who maintains the code would probably<br>>>balk.<br>>><br>
>>>From: "Deskin, Bob" <<a href="mailto:Bob.Deskin@Cognos.COM">Bob.Deskin@Cognos.COM</a>><br>>>>Date: Fri Apr 07 10:29:42 CDT 2006<br>>>>To: <a href="mailto:tmjva@verizon.net">tmjva@verizon.net
</a>, <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>>>>Subject: RE: RE: RE: Linking two Indexed Subfiles (HP)<br>>><br>>>>It looks like something's getting confused. Is this the exact message?
<br>>>>Because if it is, the generated (internal) name for both subfiles is<br>>>>the same. That would cause problems. Have you tried this in the<br>>current<br>>><br>>>>version - 8.49D1
?<br>>>><br>>>>Bob<br>>>><br>>>>-----Original Message-----<br>>>>From: powerh-l-bounces+bob.deskin=<a href="mailto:cognos.com@lists.sowder.com">cognos.com@lists.sowder.com</a><br>
>>>[mailto:<a href="mailto:powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com">powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com</a>] On<br>>>>Behalf Of Tracy Johnson<br>>>>Sent: April 7, 2006 10:56 AM
<br>>>>To: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>>>>Subject: Re: RE: RE: Linking two Indexed Subfiles (HP)<br>>>><br>>>><br>>>>Yes! It was Quiz or QTP.
<br>>>><br>>>>The error was:<br>>>>> ACC *JLCTABL.PUB45.JL LINK JL-CC TO HA-CC OF *HMCTABL<br>>>>*W* PowerHouse name for JLCTABL.PUB45 is JLCTABL.<br>>>>*W* PowerHouse name for
HMCTABL.PUBAS.MMV090 is JLCTABL.<br>>>>*E* Can't find the item JL-CC of JLCTABL.PUB45.JL.<br>>>><br>>>>(They both be indexed subfiles.)<br>>>>(No warnings nor errors appear when both subfiles were local to the
<br>>>>same logon group and account.)<br>>>><br>>>>(It was Quiz specifically. Made ya look down here!)<br>>>><br>>>>>From: "Deskin, Bob" <<a href="mailto:Bob.Deskin@Cognos.COM">
Bob.Deskin@Cognos.COM</a>><br>>>>>Date: Fri Apr 07 09:45:40 CDT 2006<br>>>>>To: <a href="mailto:tmjva@verizon.net">tmjva@verizon.net</a>, <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com
</a><br>>>>>Subject: RE: RE: Linking two Indexed Subfiles (HP)<br>>>><br>>>>>Was this QUIZ or QTP and what exactly was the error? Even though you<br>>>>>got it to work, I want to ensure that there's no issue. It may be the
<br>><br>>>>>access we need is too much regardless of the RELEASE.<br>>>>><br>>>>>Bob<br>>>>><br>>>>>-----Original Message-----<br>>>>>From: powerh-l-bounces+bob.deskin=
<a href="mailto:cognos.com@lists.sowder.com">cognos.com@lists.sowder.com</a><br>>>>>[mailto:<a href="mailto:powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com">powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com
</a>] On<br>>>>>Behalf Of Tracy Johnson<br>>>>>Sent: April 7, 2006 10:42 AM<br>>>>>To: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>>>>>Subject: Re: RE: Linking two Indexed Subfiles (HP)
<br>>>>><br>>>>><br>>>>>We be in 8.19.C3.<br>>>>><br>>>>>This was a new thing written the fly. It was something I noticed<br>>>>>while<br>>>>
<br>>>>>trying to get it to work. Note we have success, it is just the<br>>>>>method was not anticipated.<br>>>>><br>>>>>Note the files were RELEASEd. So cross-account access should not
<br>>>>>have been a problem.<br>>>>><br>>>>><br>>>>>>From: "Deskin, Bob" <<a href="mailto:Bob.Deskin@Cognos.COM">Bob.Deskin@Cognos.COM</a>><br>>>>>>Date: Fri Apr 07 08:56:46 CDT 2006
<br>>>>>>To: <a href="mailto:tmjva@verizon.net">tmjva@verizon.net</a>, <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>>>>>>Subject: RE: Linking two Indexed Subfiles (HP)
<br>>>>><br>>>>>>In 8.49D1 I am able to reference a fully qualified subfile, at least<br>>>>>>within my own account. There may be issues across accounts due to<br>>>>>>access. Which version is this and did this ever work?
<br>>>>>><br>>>>>>Bob<br>>>>>><br>>>>>>-----Original Message-----<br>>>>>>From: powerh-l-bounces+bob.deskin=<a href="mailto:cognos.com@lists.sowder.com">
cognos.com@lists.sowder.com</a><br>>>>>>[mailto:<a href="mailto:powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com">powerh-l-bounces+bob.deskin=cognos.com@lists.sowder.com</a>] On<br>>>>>>Behalf Of Tracy Johnson
<br>>>>>>Sent: April 6, 2006 5:24 PM<br>>>>>>To: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>>>>>>Subject: Linking two Indexed Subfiles (HP)<br>
>>>>><br>>>>>><br>>>>>>When accessing subfiles on the HP is there a problem when using<br>>>>>>fully<br>>><br>>>>>>qualified file names?<br>
>>>>><br>>>>>>Even though the files are RELEASEd, below doesn't work:<br>>>>>><br>>>>>>ACC *JLCTABL.PUB45.JL LINK JL-CC TO HA-CC OF *HMCTABL<br>>>>>>
<br>>>>>>If I copy the first subfile to a local account and shorten the name,<br>><br>>>>>>it<br>>>>><br>>>>>>does work.<br>>>>>><br>>>>>>ACC *JLCTABL LINK JL-CC TO HA-CC OF *HMCTABL
<br>>>>>><br>>>>>><br>>>>>><br>>>>>><br>>>>>><br>>>>>>BT<br>>>>>>Tracy Johnson<br>>>>>><a href="http://hp3000.empireclassic.com/">
http://hp3000.empireclassic.com/</a><br>>>>>><br>>>>>><br>>>>>><br>>>>>><br>>>>>><br>>>>>><br>>>>>><br>>>>>>
<br>>>>>>NNNN<br>>>>>><br>>>>>>--<br>>>>>>= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing<br>>>>>>list: <a href="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">powerh-l-request@lists.sowder.com</a><br>>>>>>Unsubscribe: "unsubscribe <password>" in message body to
<br>>>>>><a href="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">http://lists.sowder.com/mailman/listinfo/powerh-l
</a><br>>>>>>This list is closed, thus to post to the list you must be a<br>>>>>>subscriber.<br>>>>>><br>>>>>> This message may contain privileged and/or confidential
<br>>>>>> information. If you have received this e-mail in error or are not<br>>>>the<br>>>>><br>>>>>> intended recipient, you may not use, copy, disseminate or<br>>>>>> distribute
<br>>><br>>>>>> it; do not open any attachments, delete it immediately from your<br>>>>>> system and notify the sender promptly by e-mail that you have done<br>>>>so.<br>>>>>
<br>>>>>> Thank you.<br>>>>><br>>>>><br>>>>>BT<br>>>>>Tracy Johnson<br>>>>><a href="http://hp3000.empireclassic.com/">http://hp3000.empireclassic.com/
</a><br>>>>><br>>>>><br>>>>><br>>>>><br>>>>><br>>>>><br>>>>><br>>>>><br>>>>>NNNN<br>>>>><br>>>>>--
<br>>>>>= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:<br>>>>><a href="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">powerh-l-request@lists.sowder.com</a><br>>>>>Unsubscribe: "unsubscribe <password>" in message body to<br>>>>><a href="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">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>>>>>This list is closed, thus to post to the list you must be a
<br>>>>>subscriber.<br>>>>><br>>>>> This message may contain privileged and/or confidential<br>>>>> information. If you have received this e-mail in error or are not<br>
>>the<br>>>><br>>>>> intended recipient, you may not use, copy, disseminate or distribute<br>><br>>>>> it; do not open any attachments, delete it immediately from your<br>>>>> system and notify the sender promptly by e-mail that you have done
<br>>>so.<br>>>><br>>>>> Thank you.<br>>>><br>>>><br>>>>BT<br>>>>Tracy Johnson<br>>>><a href="http://hp3000.empireclassic.com/">http://hp3000.empireclassic.com/
</a><br>>>><br>>>><br>>>><br>>>><br>>>><br>>>><br>>>><br>>>><br>>>>NNNN<br>>>><br>>>>--<br>>>>= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
<br>>>><a href="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">
powerh-l-request@lists.sowder.com</a><br>>>>Unsubscribe: "unsubscribe <password>" in message body to<br>>>><a href="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">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>>>>This list is closed, thus to post to the list you must be a<br>>>>subscriber.
<br>>>><br>>>> This message may contain privileged and/or confidential<br>>>> information. If you have received this e-mail in error or are not<br>>the<br>>><br>>>> intended recipient, you may not use, copy, disseminate or distribute
<br>>>> it; do not open any attachments, delete it immediately from your<br>>>> system and notify the sender promptly by e-mail that you have done<br>>so.<br>>><br>>>> Thank you.<br>>>
<br>>><br>>>BT<br>>>Tracy Johnson<br>>><a href="http://hp3000.empireclassic.com/">http://hp3000.empireclassic.com/</a><br>>><br>>><br>>><br>>><br>>><br>>><br>>>
<br>>><br>>>NNNN<br>>><br>>>--<br>>>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>>>Mailing list: <a href="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">powerh-l-request@lists.sowder.com</a><br>>>Unsubscribe: "unsubscribe <password>" in message body to
<br>>><a href="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">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>>><br>>> This message may contain privileged and/or confidential<br>>> information. If you have received this e-mail in error or are not the
<br>><br>>> intended recipient, you may not use, copy, disseminate or distribute<br>>> it; do not open any attachments, delete it immediately from your<br>>> system and notify the sender promptly by e-mail that you have done so.
<br>><br>>> Thank you.<br>><br>><br>>BT<br>>Tracy Johnson<br>><a href="http://hp3000.empireclassic.com/">http://hp3000.empireclassic.com/</a><br>><br>><br>><br>><br>><br>><br>>
<br>><br>>NNNN<br>><br>>--<br>>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>>Mailing list: <a href="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">powerh-l-request@lists.sowder.com</a><br>>Unsubscribe: "unsubscribe <password>" in message body to<br>><a href="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">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>><br>> This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.
<br><br><br>BT<br>Tracy Johnson<br><a href="http://hp3000.empireclassic.com/">http://hp3000.empireclassic.com/</a><br><br><br><br><br><br><br><br><br>NNNN<br><br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
<br>Mailing list: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Subscribe: "subscribe" in message body to <a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com
</a><br>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to <a href="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">
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></blockquote></div><br>