Linking two Indexed Subfiles (HP)
Deskin, Bob
Bob.Deskin at Cognos.COM
Mon Apr 10 09:09:33 CDT 2006
I finally found a version of 8.19C3 to try this on. It's a bug in 8.19
that has been fixed. It no longer occurs in 8.49D1.
Regards
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 3:49 PM
To: powerh-l at lists.sowder.com
Subject: Re: RE: RE: RE: RE: Linking two Indexed Subfiles (HP)
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
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
More information about the powerh-l
mailing list