Linking two Indexed Subfiles (HP)
Wayne Dunlop
wayne.dunlop at gmail.com
Mon Apr 10 11:32:17 CDT 2006
Isn't the correct syntax "LINK VIAINDEX ..."
Wayne
On 4/10/06, Tracy Johnson <vzeo5z3y at verizon.net> wrote:
>
> 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
>
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> 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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060410/3480d431/attachment-0001.html
More information about the powerh-l
mailing list