LINKING TABLES
Guy Werry
guy.werry@hbms.ca
Wed, 17 Nov 2004 09:47:25 -0600
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C4CCBC.BC09E6E0
Content-Type: text/plain;
charset="iso-8859-1"
>From PH 7.33.D3, Ux 10.20:
First example is a COMPOSITE key: employee number and course code:
SUBFILE FS030S01 KEEP INCLUDE COURSE-DETAIL &
INDEX TRAINED &
SEGMENT EMP-NUM, &
COURSE-CODE
Second example is the more pedestrian single key (actually TWO single keys):
SUBFILE FS030S00 KEEP INCLUDE COURSE-MASTER, D-OCC-NUM &
INDEX COURSE-CODE &
SEGMENT COURSE-CODE, &
INDEX D-OCC-NUM &
SEGMENT D-OCC-NUM
Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited.
-----Original Message-----
From: Kristina Carlton [mailto:Kristina.Carlton@JICompanies.com]
Sent: Wednesday, November 17, 2004 9:30 AM
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
<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
<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
<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
<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
<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 <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
<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
<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
<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
<http://lists.sowder.com/mailman/listinfo/powerh-l>
This list is closed, thus to post to the list you must be a subscriber.
------_=_NextPart_001_01C4CCBC.BC09E6E0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: LINKING TABLES</TITLE>
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=625373615-17112004>From
PH 7.33.D3, Ux 10.20:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=625373615-17112004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=625373615-17112004>First
example is a COMPOSITE key: employee number and course
code:</SPAN></FONT></DIV><FONT face=Arial><SPAN class=625373615-17112004>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<P><FONT face=r_ansi color=#0000ff size=2>SUBFILE FS030S01 KEEP INCLUDE
COURSE-DETAIL &</FONT></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<P><FONT face=r_ansi color=#0000ff size=2>INDEX TRAINED &</FONT></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<P><FONT face=r_ansi color=#0000ff size=2>SEGMENT EMP-<SPAN
class=625373615-17112004>NUM</SPAN>, &</FONT></P>
<P><FONT face=r_ansi color=#0000ff
size=2>COURSE-CODE</FONT></P></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE>
<P dir=ltr><SPAN class=625373615-17112004><FONT face=r_ansi color=#0000ff
size=2>Second example is the more pedestrian single key (actually TWO single
keys):</FONT></SPAN></P><SPAN class=625373615-17112004>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<P><FONT face=r_ansi size=2>SUBFILE FS030S00 KEEP INCLUDE COURSE-MASTER<SPAN
class=625373615-17112004>,</SPAN> D-OCC-NUM &</FONT></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<P><FONT face=r_ansi size=2>INDEX COURSE-CODE &</FONT></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<P><FONT face=r_ansi size=2>SEGMENT COURSE-CODE,
&</FONT></P></BLOCKQUOTE>
<P><FONT face=r_ansi size=2>INDEX D-OCC-NUM &</FONT></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<P><FONT face=r_ansi size=2>SEGMENT D-OCC-NUM</FONT></P>
<P><FONT face=r_ansi
size=2></FONT> </P></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE><SPAN
class=625373615-17112004><FONT face=r_ansi size=2>
<P><FONT size=2>Guy L. Werry<BR>Senior Systems Analyst<BR>Hudson Bay Mining
& Smelting Co., Limited. </FONT></P></FONT></SPAN></SPAN></SPAN></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Kristina Carlton
[mailto:Kristina.Carlton@JICompanies.com]<BR><B>Sent:</B> Wednesday, November
17, 2004 9:30 AM<BR><B>To:</B> 'Deskin, Bob';
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: LINKING
TABLES<BR><BR></DIV></FONT>
<P><FONT size=2>Can someone tell me how to index a field in a subfile? I
cannot find the syntax in the book we have.</FONT> </P>
<P><FONT size=2>Thanks,</FONT> <BR><FONT size=2>Kristina Carlton</FONT>
<BR><FONT size=2>Senior Programmer/Analyst</FONT> <BR><FONT size=2>The JI
Companies</FONT> <BR><FONT size=2>512.427.2459</FONT> <BR><FONT
size=2>kristina.carlton@jicompanies.com</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
Deskin, Bob [<A
href="mailto:Bob.Deskin@cognos.com">mailto:Bob.Deskin@cognos.com</A>]</FONT>
<BR><FONT size=2>Sent: Wednesday, November 17, 2004 5:58 AM</FONT> <BR><FONT
size=2>To: powerh-l@lists.sowder.com</FONT> <BR><FONT size=2>Subject: RE:
LINKING TABLES</FONT> </P>
<P><FONT size=2>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.</FONT></P>
<P><FONT size=2>Bob
Deskin
</FONT><BR><FONT size=2>Senior Product Manager, Application Development
Tools</FONT> <BR><FONT size=2>Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G
4K9 CANADA</FONT> <BR><FONT size=2>bob.deskin@cognos.com (613) 738-1338 ext
7268</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
powerh-l-admin@lists.sowder.com</FONT> <BR><FONT size=2>[<A
href="mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lists.sowder.com</A>]On
Behalf Of Martijn Nabben</FONT> <BR><FONT size=2>(Fairfax)</FONT> <BR><FONT
size=2>Sent: November 16, 2004 10:25 PM</FONT> <BR><FONT size=2>To:
powerh-l@lists.sowder.com</FONT> <BR><FONT size=2>Subject: RE: LINKING
TABLES</FONT> </P><BR>
<P><FONT size=2>Yes it is,</FONT> </P>
<P><FONT size=2>We're using it all the time. It is a sincere undocumented
feature; it became</FONT> <BR><FONT size=2>official in the v8 series.</FONT>
</P>
<P><FONT size=2>NB: In case of a physically kept indexed subfile, it MUST be
in the same</FONT> <BR><FONT size=2>directory as the program that uses it, or
alternatively if your platform</FONT> <BR><FONT size=2>allows logical names
for physical directories/files, you can create a</FONT> <BR><FONT
size=2>logical name for the indexed subfile and then it doesn't matter
anymore</FONT> <BR><FONT size=2>where the file resides.</FONT> </P>
<P><FONT size=2>Vax/OpenVMS PH 7.10G</FONT> </P>
<P><FONT size=2>Cheers,</FONT> <BR><FONT size=2>Martijn Nabben</FONT>
<BR><FONT size=2>Fairfax NZ</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
powerh-l-admin@lists.sowder.com</FONT> <BR><FONT size=2>[<A
href="mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lists.sowder.com</A>]
On Behalf Of Latimer, Richard</FONT> <BR><FONT size=2>Sent: Wednesday, 17
November 2004 4:09</FONT> <BR><FONT size=2>To: brian_matthewsbrian matthews;
Kristina.Carlton@JICompanies.com;</FONT> <BR><FONT
size=2>powerh-l@lists.sowder.com</FONT> <BR><FONT size=2>Subject: RE: LINKING
TABLES</FONT> </P><BR>
<P><FONT size=2>Is 7.1 far enough up the PH food chain to be able to support
indexed</FONT> <BR><FONT size=2>subfiles and / or 'backwards' linking to them
??</FONT> </P>
<P><FONT size=2>Even if Kristina has an RDB behind her app the same problem
may exist -</FONT> <BR><FONT size=2>DB2/400 is an RDB but the PH version
available for the iSeries doesn't</FONT> <BR><FONT size=2>support any of the
neat features like indexed subfiles and the ability to</FONT> <BR><FONT
size=2>control ordering in Quick that some of you lucky listers enjoy.</FONT>
</P>
<P><FONT size=2>I suspect that the only real solution is to add a new index to
her table.</FONT> </P>
<P><FONT size=2>regards</FONT> <BR><FONT size=2>Richard</FONT> </P><BR><BR>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
powerh-l-admin@lists.sowder.com</FONT> <BR><FONT size=2>[<A
href="mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lists.sowder.com</A>]
On Behalf Of brian_matthewsbrian</FONT> <BR><FONT size=2>matthews</FONT>
<BR><FONT size=2>Sent: Wednesday, 17 November 2004 3:49 p.m.</FONT> <BR><FONT
size=2>To: Kristina.Carlton@JICompanies.com; powerh-l@lists.sowder.com</FONT>
<BR><FONT size=2>Subject: RE: LINKING TABLES</FONT> </P><BR>
<P><FONT size=2>Assuming that your file is not a table in an RDB, and that the
item</FONT> <BR><FONT size=2>DOCUMENT_NUM of DTL is not an indexed segment
there is another, but</FONT> <BR><FONT size=2>potentially very slow option,
and that is to use the linkage below.</FONT> </P>
<P><FONT size=2>ACC DTL LINK DOCUMENT_NUM TO DOCUMENT_NUM OF *
DKF1:[DW]DWDTL</FONT> </P>
<P><FONT size=2>In order to do this you will need to make your subfile indexed
on the item</FONT> <BR><FONT size=2>DOCUMENT_NUM.</FONT> </P>
<P><FONT size=2>As long as you don't use optional on the access statement it
will return</FONT> </P>
<P><FONT size=2>data only where a link was made to the subfile.</FONT> </P>
<P><FONT size=2>The other option is to make the item DOCUMENT_NUM of DTL an
indexed segment</FONT> <BR><FONT size=2>of the file and rebuild your
file.</FONT> </P>
<P><FONT size=2>I am pretty sure that only applications which wish to use the
new segment</FONT> <BR><FONT size=2>need to be recompiled once the new index
is added.</FONT> </P>
<P><FONT size=2>Bri,</FONT> </P>
<P><FONT size=2>>From: "Deskin, Bob" <Bob.Deskin@cognos.com></FONT>
<BR><FONT size=2>>To: <powerh-l@lists.sowder.com></FONT> <BR><FONT
size=2>>Subject: RE: LINKING TABLES Date: Tue, 16 Nov 2004 21:02:13
-0500</FONT> <BR><FONT size=2>></FONT> <BR><FONT size=2>>That's correct.
You can link to any column of a relational table by</FONT> <BR><FONT
size=2>>specifying the name of the column as a TO in the ACCESS. However,
that</FONT> <BR><FONT size=2>only</FONT> <BR><FONT size=2>>applies to
relational tables. To link to a non-relational indexed file</FONT> <BR><FONT
size=2>or</FONT> <BR><FONT size=2>>IMAGE (on MPE/iX), you must link to a
segment of a key or index. Bob</FONT> <BR><FONT size=2>>Deskin Senior
Product Manager, Application Development Tools</FONT> <BR><FONT
size=2>>Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA</FONT>
<BR><FONT size=2>>bob.deskin@cognos.com (613) 738-1338 ext 7268</FONT>
<BR><FONT size=2>></FONT> <BR><FONT size=2>>-----Original
Message-----</FONT> <BR><FONT size=2>>From:
powerh-l-admin@lists.sowder.com</FONT> <BR><FONT size=2>>[<A
href="mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lists.sowder.com</A>]On
Behalf Of Jonbickel@aol.com</FONT> <BR><FONT size=2>>Sent: November 16,
2004 4:57 PM</FONT> <BR><FONT size=2>>To: powerh-l@lists.sowder.com</FONT>
<BR><FONT size=2>>Subject: Re: LINKING TABLES</FONT> <BR><FONT
size=2>></FONT> <BR><FONT size=2>></FONT> <BR><FONT
size=2>>Kristina,</FONT> <BR><FONT size=2>></FONT> <BR><FONT
size=2>>By dictionary file, I assume that you mean an RMS file. IIRC,
you</FONT> <BR><FONT size=2>>cannot</FONT> <BR><FONT size=2>>link on a
non-indexed field to anything other than a relational table.</FONT> <BR><FONT
size=2>></FONT> <BR><FONT size=2>>jb</FONT> <BR><FONT size=2>></FONT>
<BR><FONT size=2>>In a message dated 11/16/2004 3:41:51 PM Central Standard
Time,</FONT> <BR><FONT size=2>>Kristina.Carlton@JICompanies.com
writes:</FONT> <BR><FONT size=2>></FONT> <BR><FONT size=2>>Hi
List,</FONT> <BR><FONT size=2>></FONT> <BR><FONT size=2>>I am using
OpenVMS v7.3-2 and Quiz V7.10.G4.</FONT> <BR><FONT size=2>></FONT>
<BR><FONT size=2>>A while back I had trouble linking tables and got some
help from this</FONT> <BR><FONT size=2>>list.</FONT> <BR><FONT
size=2>>Everything has been working great, but today I ran into a
problem</FONT> <BR><FONT size=2>again. My</FONT> <BR><FONT size=2>>attempt
is to access a subfile, then link it to a dictionary file via</FONT> <BR><FONT
size=2>one</FONT> <BR><FONT size=2>>field, which is not indexed.</FONT>
<BR><FONT size=2>></FONT> <BR><FONT size=2>>This is my access
statement:</FONT> <BR><FONT size=2>></FONT> <BR><FONT size=2>>ACC
*DKF1:[DW]DWDTL ALIAS DWDTL LINK DOCUMENT_NUM OF DWDTL TO</FONT>
<BR><FONT size=2>>DOCUMENT_NUM</FONT> <BR><FONT size=2>>OF DTL</FONT>
<BR><FONT size=2>></FONT> <BR><FONT size=2>>And the resulting error
message:</FONT> <BR><FONT size=2>></FONT> <BR><FONT size=2>>*E* Item(s)
DOCUMENT_NUM not defined as an index of DTL.</FONT> <BR><FONT
size=2>></FONT> <BR><FONT size=2>>Can someone point out what I am doing
wrong?</FONT> <BR><FONT size=2>></FONT> <BR><FONT size=2>></FONT>
<BR><FONT size=2>></FONT> <BR><FONT size=2>>Thanks,</FONT> <BR><FONT
size=2>></FONT> <BR><FONT size=2>>Kristina Carlton</FONT> <BR><FONT
size=2>></FONT> <BR><FONT size=2>>Senior Programmer/Analyst</FONT>
<BR><FONT size=2>></FONT> <BR><FONT size=2>>The JI Companies</FONT>
<BR><FONT size=2>></FONT> <BR><FONT size=2>>512.427.2459</FONT>
<BR><FONT size=2>></FONT> <BR><FONT
size=2>>kristina.carlton@jicompanies.com</FONT> <BR><FONT
size=2>></FONT> <BR><FONT
size=2>> This message may contain
privileged and/or confidential</FONT> <BR><FONT size=2>>information.
If you have received this e-mail in error or are not the</FONT> <BR><FONT
size=2>>intended recipient, you may not use, copy, disseminate or
distribute</FONT> <BR><FONT size=2>it; do</FONT> <BR><FONT size=2>>not open
any attachments, delete it immediately from your system and</FONT> <BR><FONT
size=2>notify</FONT> <BR><FONT size=2>>the sender promptly by e-mail that
you have done so. Thank you.</FONT> <BR><FONT size=2>></FONT> </P>
<P><FONT
size=2>_________________________________________________________________</FONT>
<BR><FONT size=2>It's fast, it's easy and it's free. Get MSN Messenger
today!</FONT> <BR><FONT size=2><A href="http://www.msn.co.uk/messenger"
target=_blank>http://www.msn.co.uk/messenger</A></FONT> </P>
<P><FONT size=2>= = = = = = = = = = = = = = = = = = = = = = = = = = = =</FONT>
<BR><FONT size=2>Mailing list: powerh-l@lists.sowder.com</FONT> <BR><FONT
size=2>Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com</FONT> <BR><FONT size=2>Unsubscribe:
"unsubscribe <password>" in message body to</FONT> <BR><FONT
size=2>powerh-l-request@lists.sowder.com</FONT> <BR><FONT size=2><A
href="http://lists.sowder.com/mailman/listinfo/powerh-l"
target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A></FONT>
<BR><FONT size=2>This list is closed, thus to post to the list you must be a
subscriber.</FONT> </P><BR>
<P><FONT size=2>--</FONT> <BR><FONT
size=2>**********************************************************************</FONT>
<BR><FONT size=2>This electronic message together with any attachments is
confidential. If</FONT> <BR><FONT size=2>you receive it in error: (i) you must
not use, disclose, copy or retain it;</FONT> <BR><FONT size=2>(ii) please
contact the sender immediately by reply email and then delete</FONT> <BR><FONT
size=2>the emails. Views expressed in this email may not be those of the
Airways</FONT> <BR><FONT size=2>Corporation of New Zealand Limited</FONT>
<BR><FONT
size=2>**********************************************************************</FONT>
</P><BR>
<P><FONT size=2>= = = = = = = = = = = = = = = = = = = = = = = = = = = =</FONT>
<BR><FONT size=2>Mailing list: powerh-l@lists.sowder.com</FONT> <BR><FONT
size=2>Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com</FONT> <BR><FONT size=2>Unsubscribe:
"unsubscribe <password>" in message body to</FONT> <BR><FONT
size=2>powerh-l-request@lists.sowder.com</FONT> <BR><FONT size=2><A
href="http://lists.sowder.com/mailman/listinfo/powerh-l"
target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A></FONT>
<BR><FONT size=2>This list is closed, thus to post to the list you must be a
subscriber.</FONT> <BR><FONT size=2>= = = = = = = = = = = = = = = = = = = = =
= = = = = = =</FONT> <BR><FONT size=2>Mailing list:
powerh-l@lists.sowder.com</FONT> <BR><FONT size=2>Subscribe: "subscribe" in
message body to powerh-l-request@lists.sowder.com</FONT> <BR><FONT
size=2>Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com</FONT> <BR><FONT size=2><A
href="http://lists.sowder.com/mailman/listinfo/powerh-l"
target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A></FONT>
<BR><FONT size=2>This list is closed, thus to post to the list you must be a
subscriber.</FONT> <BR><FONT size=2> </FONT> <BR><FONT
size=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><BR>
<P><FONT size=2>= = = = = = = = = = = = = = = = = = = = = = = = = = = =</FONT>
<BR><FONT size=2>Mailing list: powerh-l@lists.sowder.com</FONT> <BR><FONT
size=2>Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com</FONT> <BR><FONT size=2>Unsubscribe:
"unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com</FONT> <BR><FONT size=2><A
href="http://lists.sowder.com/mailman/listinfo/powerh-l"
target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A></FONT>
<BR><FONT size=2>This list is closed, thus to post to the list you must be a
subscriber.</FONT> </P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C4CCBC.BC09E6E0--