LINKING TABLES
Deskin, Bob
Bob.Deskin@Cognos.COM
Tue, 16 Nov 2004 21:02:13 -0500
This is a multi-part message in MIME format.
------_=_NextPart_001_01C4CC49.748D4E85
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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 =20
Senior Product Manager, Application Development Tools=20
Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA=20
bob.deskin@cognos.com (613) 738-1338 ext 7268=20
-----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=20
Kristina,
=20
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.
=20
jb
=20
In a message dated 11/16/2004 3:41:51 PM Central Standard Time, =
Kristina.Carlton@JICompanies.com writes:
Hi List,=20
I am using OpenVMS v7.3-2 and Quiz V7.10.G4.=20
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?
=20
Thanks,
Kristina Carlton
Senior Programmer/Analyst
The JI Companies
512.427.2459
kristina.carlton@jicompanies.com=20
=20
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.=20
=20
------_=_NextPart_001_01C4CC49.748D4E85
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<HTML xmlns:eXclaimer=3D"http://www.exclaimer.co.uk">
<HEAD>
<META http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3DUTF-16">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUTF-16">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4943.400" name=3DGENERATOR></HEAD><BODY =
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; BACKGROUND-COLOR: =
#ffffff"><DIV>
<DIV><SPAN class=3D982580002-17112004>That's correct. You can link to =
any column=20
of a relational table by specifying the name of the column as a TO in =
the=20
ACCESS. However, that only applies to relational tables. To link to a=20
non-relational indexed file or IMAGE (on MPE/iX), you must link to a =
segment of=20
a key or index.</SPAN></DIV>
<DIV><SPAN class=3D982580002-17112004>
<P><FONT face=3DArial size=3D2>Bob=20
Deskin &=
nbsp; =20
</FONT><BR><FONT face=3DArial size=3D2>Senior</FONT> <FONT face=3DArial =
size=3D2>Product=20
Manager</FONT><FONT face=3DArial size=3D2>,</FONT> <FONT face=3DArial=20
size=3D2>Application Development Tools</FONT> <BR><FONT face=3DArial =
size=3D2>Cognos=20
Inc.</FONT><FONT face=3DArial size=3D2></FONT> <FONT face=3DArial =
size=3D2>3755=20
Riverside Drive</FONT><FONT face=3DArial size=3D2>,</FONT> <FONT =
face=3DArial=20
size=3D2>Ottawa ON K1G 4K9 CANADA</FONT> <BR><FONT face=3DArial=20
size=3D2>bob.deskin@cognos.com</FONT><FONT face=3DArial size=3D2></FONT> =
<FONT=20
face=3DArial size=3D2>(613) 738-1338 ext</FONT> <FONT face=3DArial =
size=3D2>7268</FONT>=20
</P></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT=20
face=3DTahoma>-----Original Message-----<BR><B>From:</B>=20
powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com]<B>On=20
Behalf Of </B>Jonbickel@aol.com<BR><B>Sent:</B> November 16, 2004 4:57 =
PM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> Re: =
LINKING=20
TABLES <BR><BR></FONT></DIV>
<DIV>
<DIV>Kristina,</DIV>
<DIV> </DIV>
<DIV>By dictionary file, I assume that you mean an RMS file. =
IIRC, you=20
cannot link on a non-indexed field to anything other than a relational =
table.</DIV>
<DIV> </DIV>
<DIV>jb</DIV>
<DIV> </DIV>
<DIV>In a message dated 11/16/2004 3:41:51 PM Central Standard Time,=20
Kristina.Carlton@JICompanies.com writes:</DIV>
<BLOCKQUOTE=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: blue 2px =
solid">
<P style=3D"MARGIN-RIGHT: 0.5in"><FONT color=3Dblue size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: 'Century Gothic'; =
mso-bidi-font-size: 10.0pt">Hi=20
List,</SPAN></FONT><FONT color=3Dblue size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: 'Century Gothic'; =
mso-bidi-font-size: 12.0pt">=20
<o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-RIGHT: 0.5in"><FONT color=3Dblue size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: 'Century Gothic'; =
mso-bidi-font-size: 10.0pt">I=20
am using OpenVMS v7.3-2 and Quiz V7.10.G4.</SPAN></FONT><FONT =
color=3Dblue=20
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: 'Century Gothic'; =
mso-bidi-font-size: 12.0pt">=20
<o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-RIGHT: 0.5in"><FONT color=3Dblue size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: 'Century Gothic'; =
mso-bidi-font-size: 12.0pt">A=20
while back I had trouble linking tables and got some help from this =
list.=20
Everything has been working great, but today I ran into a problem =
again. My=20
attempt is to access a subfile, then link it to a dictionary file =
via one=20
field, which is not indexed.<o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-RIGHT: 0.5in"><FONT color=3Dblue size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: 'Century Gothic'; =
mso-bidi-font-size: 12.0pt">This=20
is my access statement:<o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-RIGHT: 0.5in"><FONT color=3D#333399 =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: #333399; FONT-FAMILY: 'Century =
Gothic'; mso-bidi-font-size: 12.0pt">ACC=20
*DKF1:[DW]DWDTL ALIAS DWDTL LINK DOCUMENT_NUM OF DWDTL <SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>TO DOCUMENT_NUM OF=20
DTL</SPAN></FONT><FONT color=3D#333399 size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: #333399; FONT-FAMILY: 'Century =
Gothic'; mso-bidi-font-size: 12.0pt; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-RIGHT: 0.5in"><FONT color=3Dblue size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue; FONT-FAMILY: 'Century Gothic'; =
mso-bidi-font-size: 12.0pt">And=20
the resulting error message:<o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-RIGHT: 0.5in"><FONT color=3D#333399 =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: #333399; FONT-FAMILY: 'Century =
Gothic'; mso-bidi-font-size: 12.0pt">*E*=20
Item(s) DOCUMENT_NUM not defined as an index of =
DTL.</SPAN></FONT><FONT=20
color=3D#333399 size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: #333399; FONT-FAMILY: 'Century =
Gothic'; mso-bidi-font-size: 12.0pt; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT color=3Dblue =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue"><SPAN=20
style=3D"mso-bidi-font-size: 12.0pt"><FONT face=3D"Century =
Gothic">Can someone=20
point out what I am doing=20
wrong?<o:p></o:p></FONT></SPAN></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT color=3Dblue =
size=3D1><FONT=20
face=3D"Century Gothic"><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: =
blue"> </SPAN><o:p></o:p></FONT></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle15><FONT color=3Dblue =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue"><SPAN=20
style=3D"mso-bidi-font-size: 12.0pt"><FONT=20
face=3D"Century =
Gothic">Thanks,<o:p></o:p></FONT></SPAN></SPAN></FONT></SPAN></P>
<P class=3DMsoAutoSig><FONT color=3Dblue><SPAN style=3D"COLOR: =
blue"><FONT=20
face=3D"Century Gothic">Kristina =
Carlton<o:p></o:p></FONT></SPAN></FONT></P>
<P class=3DMsoAutoSig><FONT color=3Dblue size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue"><SPAN=20
style=3D"mso-bidi-font-size: 12.0pt"><FONT face=3D"Century =
Gothic">Senior=20
Programmer/Analyst<o:p></o:p></FONT></SPAN></SPAN></FONT></P>
<P class=3DMsoAutoSig><FONT color=3Dblue size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue"><SPAN=20
style=3D"mso-bidi-font-size: 12.0pt"><FONT face=3D"Century =
Gothic">The JI=20
Companies<o:p></o:p></FONT></SPAN></SPAN></FONT></P>
<P class=3DMsoAutoSig><FONT color=3Dblue size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue"><SPAN=20
style=3D"mso-bidi-font-size: 12.0pt"><FONT=20
face=3D"Century =
Gothic">512.427.2459<o:p></o:p></FONT></SPAN></SPAN></FONT></P>
<P class=3DMsoAutoSig><FONT face=3D"Century Gothic" color=3Dblue =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 9pt; COLOR: blue"><SPAN=20
style=3D"mso-bidi-font-size: =
12.0pt">kristina.carlton@jicompanies.com</SPAN></SPAN></FONT></P></BLOCKQ=
UOTE></DIV>
<DIV></DIV></BLOCKQUOTE></DIV>
<DIV> </DIV>
<DIV>
<P> <FONT FACE=3D"Arial" =
SIZE=3D"2">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.</FONT>
</P>
</DIV></BODY></HTML>
------_=_NextPart_001_01C4CC49.748D4E85--