LINKING TABLES

Wed, 17 Nov 2004 16:24:50 +1300

Yes it is,

We're using it all the time. It is a sincere undocumented feature; it became
official in the v8 series.

NB: In case of a physically kept indexed subfile, it MUST be in the same
directory as the program that uses it, or alternatively if your platform
allows logical names for physical directories/files, you can create a
logical name for the indexed subfile and then it doesn't matter anymore
where the file resides.

Vax/OpenVMS PH 7.10G

Cheers,
Martijn Nabben
Fairfax NZ

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Latimer, Richard
Sent: Wednesday, 17 November 2004 4:09 
To: brian_matthewsbrian matthews; Kristina.Carlton@JICompanies.com;
powerh-l@lists.sowder.com
Subject: RE: LINKING TABLES

Is 7.1 far enough up the PH food chain to be able to support indexed
subfiles and / or 'backwards' linking to them ?? 

Even if Kristina has an RDB behind her app the same problem may exist -
DB2/400 is an RDB but the PH version available for the iSeries doesn't
support any of the neat features like indexed subfiles and the ability to
control ordering in Quick that some of you lucky listers enjoy.

I suspect that the only real solution is to add a new index to her table.

regards
Richard

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of brian_matthewsbrian
matthews
Sent: Wednesday, 17 November 2004 3:49 p.m.
To: Kristina.Carlton@JICompanies.com; powerh-l@lists.sowder.com
Subject: RE: LINKING TABLES

Assuming that your file is not a table in an RDB, and that the item 
DOCUMENT_NUM of DTL is not an indexed segment there is another, but 
potentially very slow option, and that is to use the linkage below.

ACC  DTL LINK DOCUMENT_NUM TO DOCUMENT_NUM OF * DKF1:[DW]DWDTL

In order to do this you will need to make your subfile indexed on the item 
DOCUMENT_NUM.

As long as you don't use optional on the access statement it will return

data only where a link was made to the subfile.

The other option is to make the item DOCUMENT_NUM of DTL an indexed segment 
of the file and rebuild your file.

I am pretty sure that only applications which wish to use the new segment 
need to be recompiled once the new index is added.

Bri,

>From: "Deskin, Bob" <Bob.Deskin@cognos.com>
>To: <powerh-l@lists.sowder.com>
>Subject: RE: LINKING TABLES Date: Tue, 16 Nov 2004 21:02:13 -0500
>
>That's correct. You can link to any column of a relational table by 
>specifying the name of the column as a TO in the ACCESS. However, that
only 
>applies to relational tables. To link to a non-relational indexed file
or 
>IMAGE (on MPE/iX), you must link to a segment of a key or index. Bob 
>Deskin Senior Product Manager, Application Development Tools
>Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA
>bob.deskin@cognos.com (613) 738-1338 ext 7268
>
>-----Original Message-----
>From: powerh-l-admin@lists.sowder.com 
>[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Jonbickel@aol.com
>Sent: November 16, 2004 4:57 PM
>To: powerh-l@lists.sowder.com
>Subject: Re: LINKING TABLES
>
>
>Kristina,
>
>By dictionary file, I assume that you mean an RMS file.  IIRC, you
>cannot
>link on a non-indexed field to anything other than a relational table.
>
>jb
>
>In a message dated 11/16/2004 3:41:51 PM Central Standard Time, 
>Kristina.Carlton@JICompanies.com writes:
>
>Hi List,
>
>I am using OpenVMS v7.3-2 and Quiz V7.10.G4.
>
>A while back I had trouble linking tables and got some help from this
>list.
>Everything has been working great, but today I ran into a problem
again. My 
>attempt is to access a subfile, then link it to a dictionary file via
one 
>field, which is not indexed.
>
>This is my access statement:
>
>ACC *DKF1:[DW]DWDTL ALIAS DWDTL LINK DOCUMENT_NUM OF DWDTL  TO
>DOCUMENT_NUM
>OF DTL
>
>And the resulting error message:
>
>*E* Item(s) DOCUMENT_NUM not defined as an index of DTL.
>
>Can someone point out what I am doing wrong?
>
>
>
>Thanks,
>
>Kristina Carlton
>
>Senior Programmer/Analyst
>
>The JI Companies
>
>512.427.2459
>
>kristina.carlton@jicompanies.com
>
>        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.
>

_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! 
http://www.msn.co.uk/messenger

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@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 electronic message together with any attachments is confidential. If
you receive it in error: (i) you must not use, disclose, copy or retain it;
(ii) please contact the sender immediately by reply email and then delete
the emails. Views expressed in this email may not be those of the Airways
Corporation of New Zealand Limited
**********************************************************************

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@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.