LINKING TABLES

Wed, 17 Nov 2004 15:38:49 -0000

This is a multi-part message in MIME format.

------=_NextPart_000_000A_01C4CCBB.885614F0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Try something like that below,

set subf name lots_180904 keep index lot_char_dates segment lot_char_dates ,
lot_item_all

rep sum lot_char_dates  lot_item_all other items.

to check results, do the below,

qshow

> sho sub lots_180904

Regards, Joe.

This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this e-mail and any
attachments sent with it may have been altered without the consent or
knowledge of the author.

  _____  

From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Kristina Carlton
Sent: 17 November 2004 15:30
To: 'Deskin, Bob'; powerh-l@lists.sowder.com
Subject: RE: LINKING TABLES

Can someone tell me how to index a field in a subfile? I cannot find the
syntax in the book we have. 

Thanks, 
Kristina Carlton 
Senior Programmer/Analyst 
The JI Companies 
512.427.2459 
kristina.carlton@jicompanies.com 

-----Original Message----- 
From: Deskin, Bob [mailto:Bob.Deskin@cognos.com] 
Sent: Wednesday, November 17, 2004 5:58 AM 
To: powerh-l@lists.sowder.com 
Subject: RE: LINKING TABLES 

Indexed subfiles (on OpenVMS) were introduced in 7.10E1 if I recall
correctly. 7.10E did not have them. I seem to recall it was a case of trying
to meet a schedule (please be polite and don't hurt yourselves laughing) and
some features slipped. When we released E1, we included the indexed
subfiles. It would have been documented in a new features book or release
notes but probably not in the main manual.

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 Martijn Nabben 
(Fairfax) 
Sent: November 16, 2004 10:25 PM 
To: powerh-l@lists.sowder.com 
Subject: RE: LINKING TABLES 

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

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

------=_NextPart_000_000A_01C4CCBB.885614F0
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>RE: LINKING TABLES</title>
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:blue;
	text-decoration:underline;}
p
	{mso-margin-top-alt:auto;
	margin-right:0cm;
	mso-margin-bottom-alt:auto;
	margin-left:0cm;
	font-size:12.0pt;
	font-family:"Times New Roman";}
span.EmailStyle18
	{mso-style-type:personal-reply;
	font-family:Arial;
	color:navy;}
@page Section1
	{size:612.0pt 792.0pt;
	margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dblue>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Try something like that =
below,<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>set subf name lots_180904 keep =
index
lot_char_dates segment lot_char_dates , =
lot_item_all<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>rep sum lot_char_dates =
&nbsp;lot_item_all other
items&#8230;<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>to check results, do the =
below,<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>qshow<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&gt; sho sub =
lots_180904<o:p></o:p></span></font></p>

<div>

<p><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:navy'>Regards, Joe.<o:p></o:p></span></font></p>

This e-mail and all information contained in it is
confidential and may be legally privileged. If you are not the =
intended recipient,
your access to this e-mail is unauthorized. Any use, dissemination,
distribution, publication or copying by you of this e-mail or any of the
information contained within it is prohibited and may be unlawful. Do =
not open
any attachments, delete it immediately from your system and notify the =
sender
promptly by e-mail that you have done so. The content of this e-mail and =
any
attachments sent with it may have been altered without the consent or =
knowledge
of the author.<o:p></o:p>

</div>

<div>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>

<hr size=3D3 width=3D"100%" align=3Dcenter tabindex=3D-1>

</span></font></div>

<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font =
size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'> =
powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] <b><span =
style=3D'font-weight:bold'>On
Behalf Of </span></b>Kristina Carlton<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 17 November 2004 =
15:30<br>
<b><span style=3D'font-weight:bold'>To:</span></b> 'Deskin, Bob';
powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: LINKING =
TABLES</span></font><o:p></o:p></p>

</div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

Can
someone tell me how to index a field in a subfile? I cannot find the =
syntax in
the book we have. <o:p></o:p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>Thanks,</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Kristina =
Carlton</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Senior =
Programmer/Analyst</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>The JI =
Companies</span></font> <br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>512.427.2459</span></font> <br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>kristina.carlton@jicompanies.com</span></font>=

<o:p></o:p></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>-----Original
Message-----</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>From: Deskin, Bob [<a
href=3D"mailto:Bob.Deskin@cognos.com">mailto:Bob.Deskin@cognos.com</a>]</=
span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Sent: Wednesday, =
November 17, 2004
5:58 AM</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>To: =
powerh-l@lists.sowder.com</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Subject: RE: LINKING =
TABLES</span></font>
<o:p></o:p></p>

Indexed
subfiles (on OpenVMS) were introduced in 7.10E1 if I recall correctly. =
7.10E
did not have them. I seem to recall it was a case of trying to meet a =
schedule
(please be polite and don't hurt yourselves laughing) and some features
slipped. When we released E1, we included the indexed subfiles. It would =
have
been documented in a new features book or release notes but probably not =
in the
main manual.<o:p></o:p>

Bob
Deskin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp; 
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 <o:p></o:p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>-----Original
Message-----</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>From:
powerh-l-admin@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>[<a
href=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lis=
ts.sowder.com</a>]On
Behalf Of Martijn Nabben</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>(Fairfax)</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Sent: November 16, 2004 =
10:25 PM</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>To: =
powerh-l@lists.sowder.com</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Subject: RE: LINKING =
TABLES</span></font>
<o:p></o:p></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>Yes it
is,</span></font> <o:p></o:p></p>

We're
using it all the time. It is a sincere undocumented feature; it =
became
 
official in the v8 =
series.
<o:p></o:p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>NB: In
case of a physically kept indexed subfile, it MUST be in the =
same</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>directory as the program =
that uses
it, or alternatively if your platform</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>allows logical names for =
physical
directories/files, you can create a</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>logical name for the =
indexed
subfile and then it doesn't matter anymore</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>where the file =
resides.</span></font>
<o:p></o:p></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>Vax/OpenVMS
PH 7.10G</span></font> <o:p></o:p></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>Cheers,</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Martijn =
Nabben</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Fairfax NZ</span></font> =
<o:p></o:p></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>-----Original
Message-----</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>From:
powerh-l-admin@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>[<a
href=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lis=
ts.sowder.com</a>]
On Behalf Of Latimer, Richard</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Sent: Wednesday, 17 =
November 2004
4:09</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>To: brian_matthewsbrian =
matthews;
Kristina.Carlton@JICompanies.com;</span></font> <br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>powerh-l@lists.sowder.com</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Subject: RE: LINKING =
TABLES</span></font>
<o:p></o:p></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>Is 7.1
far enough up the PH food chain to be able to support =
indexed</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>subfiles and / or =
'backwards'
linking to them ??</span></font> <o:p></o:p></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>Even if
Kristina has an RDB behind her app the same problem may exist =
-</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>DB2/400 is an RDB but =
the PH
version available for the iSeries doesn't</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>support any of the neat =
features
like indexed subfiles and the ability to</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>control ordering in =
Quick that some
of you lucky listers enjoy.</span></font> <o:p></o:p></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>I suspect
that the only real solution is to add a new index to her =
table.</span></font> <o:p></o:p></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>regards</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Richard</span></font> =
<o:p></o:p></p>

<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D3
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>-----Original
Message-----</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>From:
powerh-l-admin@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>[<a
href=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lis=
ts.sowder.com</a>]
On Behalf Of brian_matthewsbrian</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>matthews</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Sent: Wednesday, 17 =
November 2004
3:49 p.m.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>To:
Kristina.Carlton@JICompanies.com; =
powerh-l@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Subject: RE: LINKING =
TABLES</span></font>
<o:p></o:p></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>Assuming
that your file is not a table in an RDB, and that the item</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>DOCUMENT_NUM of DTL is =
not an
indexed segment there is another, but</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>potentially very slow =
option, and
that is to use the linkage below.</span></font> <o:p></o:p></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>ACC&nbsp;
DTL LINK DOCUMENT_NUM TO DOCUMENT_NUM OF * DKF1:[DW]DWDTL</span></font> =
<o:p></o:p></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>In order
to do this you will need to make your subfile indexed on the =
item</span></font>
<br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>DOCUMENT_NUM.</span></font> <o:p></o:p></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>As long
as you don't use optional on the access statement it will =
return</span></font> <o:p></o:p></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>data only
where a link was made to the subfile.</span></font> <o:p></o:p></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>The other
option is to make the item DOCUMENT_NUM of DTL an indexed =
segment</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>of the file and rebuild =
your file.</span></font>
<o:p></o:p></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>I am
pretty sure that only applications which wish to use the new =
segment</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>need to be recompiled =
once the new
index is added.</span></font> <o:p></o:p></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>Bri,</span></font>
<o:p></o:p></p>

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

This message may contain privileged and/or confidential</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>&gt;information.&nbsp; =
If you have
received this e-mail in error or are not the</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>&gt;intended recipient, =
you may not
use, copy, disseminate or distribute</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>it; do</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>&gt;not open any =
attachments,
delete it immediately from your system and</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>notify</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>&gt;the sender promptly =
by e-mail
that you have done so.&nbsp; Thank you.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>&gt;</span></font> =
<o:p></o:p></p>

______________________________________________=
___________________
 
It's fast, it's easy and =
it's free.
Get MSN Messenger today! 
<a
href=3D"http://www.msn.co.uk/messenger" =
target=3D"_blank">http://www.msn.co.uk/messenger</a>
<o:p></o:p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>=3D =3D =3D =3D =3D
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Mailing list:
powerh-l@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Subscribe: =
&quot;subscribe&quot; in
message body to powerh-l-request@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Unsubscribe: =
&quot;unsubscribe
&lt;password&gt;&quot; in message body to</span></font> <br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>powerh-l-request@lists.sowder.com</span></font=
>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'><a
href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l" =
target=3D"_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a></=
span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>This list is closed, =
thus to post
to the list you must be a subscriber.</span></font> <o:p></o:p></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

--
 
**********************************************=
************************
 
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
 
**********************************************=
************************
<o:p></o:p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>=3D =3D =3D =3D =3D
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Mailing list:
powerh-l@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Subscribe: =
&quot;subscribe&quot; in
message body to powerh-l-request@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Unsubscribe: =
&quot;unsubscribe
&lt;password&gt;&quot; in message body to</span></font> <br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>powerh-l-request@lists.sowder.com</span></font=
>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'><a
href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l" =
target=3D"_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a></=
span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>This list is closed, =
thus to post
to the list you must be a subscriber.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>=3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Mailing list:
powerh-l@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Subscribe: =
&quot;subscribe&quot; in
message body to powerh-l-request@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Unsubscribe: =
&quot;unsubscribe
&lt;password&gt;&quot; in message body to =
powerh-l-request@lists.sowder.com</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'><a
href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l" =
target=3D"_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a></=
span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>This list is closed, =
thus to post
to the list you must be a subscriber.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>&nbsp;</span></font> =
<br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
This message may contain privileged and/or confidential =
information.&nbsp; 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.&nbsp; Thank you.</span></font><o:p></o:p></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>=3D =3D =3D =3D =3D
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Mailing list:
powerh-l@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Subscribe: =
&quot;subscribe&quot; in
message body to powerh-l-request@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Unsubscribe: =
&quot;unsubscribe
&lt;password&gt;&quot; in message body to =
powerh-l-request@lists.sowder.com</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'><a
href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l" =
target=3D"_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a></=
span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>This list is closed, =
thus to post
to the list you must be a subscriber.</span></font> <o:p></o:p></p>

</div>

</body>

</html>

------=_NextPart_000_000A_01C4CCBB.885614F0--