Linking two Indexed Subfiles (HP)

Tracy Johnson vzeo5z3y at verizon.net
Fri Apr 7 14:48:44 CDT 2006 

I made the change, it works one way but not the other.  User is logged into the group and account that HMCTABL is in.  Two access statements below.  (GO statements removed.)

Q U I Z   (PowerHouse  8.19.C3)
Copyright 1998 COGNOS INCORPORATED
LUCAS CONTROL SYSTEMS PRODUCTS

> USE MYCTABL.QUIZ LIST
> ACC *JLCTABL.PUB45.JL LINK JL-CC OF JLCTABL TO HA-CC OF *HMCTABL
*W* PowerHouse name for JLCTABL.PUB45.JL is JLCTABL.
> REPORT ALL
> SET REP SPACING 1
> SET REPORT LIMIT 2222
> ACC *HMCTABL LINK HA-CC OF HMCTABL TO JL-CC OF *JLCTABL.PUB45.JL
*W* PowerHouse name for JLCTABL.PUB45.JL is JLCTABL.
*E* Can't find the item JL-CC OF JLCTABL.PUB45.JL.
> REPORT ALL
> SET REP SPACING 1
> SET REPORT LIMIT 2222

QSHOW follows:

- SHOW SUBFILE HMCTABL
06/04/07                    SUBFILE DICTIONARY                    Page    1
                           SUBFILE RECORD REPORT


    Subfile:            HMCTABL
    Type:               Permanent
    Organization:       Indexed
    Format:             8
    Record Size:        38 Bytes

 Item                                 Type             Offset Size  Occurs

 HA-CC                                IEEE FLOAT       0      8
 CHEADER                              CHARACTER        8      30

-- Index Contents --

 ** HA-CC is a 8 byte   REPEATING PRIMARY  index **


    Segment                              Type            Size  Ord  Offset
    HA-CC                                IEEE FLOAT         8    A       0

 ?

- SHOW SUBFILE JLCTABL
06/04/07                    SUBFILE DICTIONARY                    Page    1
                           SUBFILE RECORD REPORT


    Subfile:            JLCTABL
    Type:               Permanent
    Organization:       Indexed
    Format:             8
    Record Size:        38 Bytes

 Item                                 Type             Offset Size  Occurs

 JL-CC                                IEEE FLOAT       0      8
 CHEADER                              CHARACTER        8      30

-- Index Contents --

 ** JL-CC is a 8 byte   REPEATING PRIMARY  index **


    Segment                              Type            Size  Ord  Offset
    JL-CC                                IEEE FLOAT         8    A       0

 ?

- 


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

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

More information about the powerh-l mailing list