Linking two Indexed Subfiles (HP)
Tracy Johnson
vzeo5z3y at verizon.net
Mon Apr 10 09:17:43 CDT 2006
I suppose it is time to call support for new tapes... I bet my 2004 unopened 8.49D tapes won't do.
(They still make tapes don't they?)
>From: "Deskin, Bob" <Bob.Deskin at Cognos.COM>
>Date: Mon Apr 10 09:09:33 CDT 2006
>To: tmjva at verizon.net, powerh-l at lists.sowder.com
>Subject: RE: RE: RE: RE: RE: Linking two Indexed Subfiles (HP)
>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.
BT
Tracy Johnson
http://hp3000.empireclassic.com/
NNNN
More information about the powerh-l
mailing list