Linking two Indexed Subfiles (HP)

Fri Apr 7 13:56:42 CDT 2006

Have you tried qualifying JL-CC as in

ACC *JLCTABL.PUB45.JL LINK JL-CC OF JCLTABL TO HA-CC OF *HMCTABL

And if you do a SHOW SUBFILE in QSHOW, does JL-CC exist?

Bob

-----Original Message-----
From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com] On
Behalf Of Tracy Johnson
Sent: April 7, 2006 11:52 AM
To: powerh-l at lists.sowder.com
Subject: Re: RE: RE: RE: Linking two Indexed Subfiles (HP)

Sorry I retyped it instead of cutting and pasting.  The corrected
message below is:

>> ACC *JLCTABL.PUB45.JL LINK JL-CC TO HA-CC OF *HMCTABL
>*W* PowerHouse name for HMCTABL.PUBAS.MMV090 is HMCTABL.
>*W* PowerHouse name for JLCTABL.PUB45 is JLCTABL.
>*E* Can't find the item JL-CC of JLCTABL.PUB45.JL.

I still have unopened tapes for 8.49D sitting on my desk since 2004.
Haven't upgraded since it is not done lightly with several hundred users
and our programming staff who maintains the code would probably balk.

>From: "Deskin, Bob" <Bob.Deskin at Cognos.COM>
>Date: Fri Apr 07 10:29:42 CDT 2006
>To: tmjva at verizon.net, powerh-l at lists.sowder.com
>Subject: RE: RE: RE: Linking two Indexed Subfiles (HP)

>It looks like something's getting confused. Is this the exact message? 
>Because if it is, the generated (internal) name for both subfiles is 
>the same. That would cause problems. Have you tried this in the current

>version - 8.49D1?
>
>Bob
>
>-----Original Message-----
>From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com
>[mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com] On 
>Behalf Of Tracy Johnson
>Sent: April 7, 2006 10:56 AM
>To: powerh-l at lists.sowder.com
>Subject: Re: RE: RE: Linking two Indexed Subfiles (HP)
>
>
>Yes!  It was Quiz or QTP.
>
>The error was:
>> ACC *JLCTABL.PUB45.JL LINK JL-CC TO HA-CC OF *HMCTABL
>*W* PowerHouse name for JLCTABL.PUB45 is JLCTABL.
>*W* PowerHouse name for HMCTABL.PUBAS.MMV090 is JLCTABL.
>*E* Can't find the item JL-CC of JLCTABL.PUB45.JL.
>
>(They both be indexed subfiles.)
>(No warnings nor errors appear when both subfiles were local to the 
>same logon group and account.)
>
>(It was Quiz specifically.  Made ya look down here!)
>
>>From: "Deskin, Bob" <Bob.Deskin at Cognos.COM>
>>Date: Fri Apr 07 09:45:40 CDT 2006
>>To: tmjva at verizon.net, powerh-l at lists.sowder.com
>>Subject: RE: RE: Linking two Indexed Subfiles (HP)
>
>>Was this QUIZ or QTP and what exactly was the error? Even though you
>>got it to work, I want to ensure that there's no issue. It may be the 
>>access we need is too much regardless of the RELEASE.
>>
>>Bob
>>
>>-----Original Message-----
>>From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com
>>[mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com] On
>>Behalf Of Tracy Johnson
>>Sent: April 7, 2006 10:42 AM
>>To: powerh-l at lists.sowder.com
>>Subject: Re: RE: Linking two Indexed Subfiles (HP)
>>
>>
>>We be in 8.19.C3.
>>
>>This was a new thing written the fly.  It was something I noticed 
>>while
>
>>trying to get it to work.  Note we have success, it is just the method
>>was not anticipated.
>>
>>Note the files were RELEASEd.  So cross-account access should not have
>>been a problem.
>>
>>
>>>From: "Deskin, Bob" <Bob.Deskin at Cognos.COM>
>>>Date: Fri Apr 07 08:56:46 CDT 2006
>>>To: tmjva at verizon.net, powerh-l at lists.sowder.com
>>>Subject: RE: Linking two Indexed Subfiles (HP)
>>
>>>In 8.49D1 I am able to reference a fully qualified subfile, at least 
>>>within my own account. There may be issues across accounts due to 
>>>access. Which version is this and did this ever work?
>>>
>>>Bob
>>>
>>>-----Original Message-----
>>>From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com
>>>[mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com] On 
>>>Behalf Of Tracy Johnson
>>>Sent: April 6, 2006 5:24 PM
>>>To: powerh-l at lists.sowder.com
>>>Subject: Linking two Indexed Subfiles (HP)
>>>
>>>
>>>When accessing subfiles on the HP is there a problem when using fully

>>>qualified file names?
>>>
>>>Even though the files are RELEASEd, below doesn't work:
>>>
>>>ACC *JLCTABL.PUB45.JL LINK JL-CC TO HA-CC OF *HMCTABL
>>>
>>>If I copy the first subfile to a local account and shorten the name,
>>>it
>>
>>>does work.
>>>
>>>ACC *JLCTABL LINK JL-CC TO HA-CC OF *HMCTABL
>>>
>>>
>>>
>>>
>>>
>>>BT
>>>Tracy Johnson
>>>http://hp3000.empireclassic.com/
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>NNNN
>>>
>>>--
>>>= = = = = = = = = = = = = = = = = = = = = = = = = = = = 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.
>>> 
>>>     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.
>>
>>
>>BT
>>Tracy Johnson
>>http://hp3000.empireclassic.com/
>>
>>
>>
>>
>>
>>
>>
>>
>>NNNN
>>
>>--
>>= = = = = = = = = = = = = = = = = = = = = = = = = = = = 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.
>> 
>>     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.
>
>
>BT
>Tracy Johnson
>http://hp3000.empireclassic.com/
>
>
>
>
>
>
>
>
>NNNN
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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.
> 
>     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.

BT
Tracy Johnson
http://hp3000.empireclassic.com/

NNNN

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.

     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.