<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3157" name=GENERATOR><!--[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]-->
<STYLE>@font-face {
font-family: Courier;
}
@font-face {
font-family: Courier;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@font-face {
font-family: r_ansi;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
LI.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
DIV.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal
}
SPAN.EmailStyle18 {
COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal
}
SPAN.EmailStyle19 {
COLOR: navy; FONT-FAMILY: "Arial","sans-serif"; mso-style-type: personal
}
SPAN.EmailStyle20 {
COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-reply
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=493042315-16102009>Kathy,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=493042315-16102009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=493042315-16102009>There are two problems here:</SPAN></FONT></DIV>
<UL dir=ltr>
<LI>
<DIV align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=493042315-16102009>POLINE is NOT a KEY, so you can't make that linkage,
unless you put it into a SELECT statement</SPAN></FONT></DIV></LI>
<LI>
<DIV align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=493042315-16102009>aliasing to POFIL2 is going to cause serious issues -
that logic doesn't look right - you are going to wind up with POFIL2 ONLY
linked by the PO line number, which won't give you what you
expect.</SPAN></FONT></DIV></LI></UL>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=493042315-16102009>
<P><FONT size=2>Guy L. Werry<BR>Senior Systems Analyst<BR>Hudson Bay Mining
& Smelting Co., Limited. </FONT></P></SPAN></FONT></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com
[mailto:powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com] <B>On Behalf Of
</B>Goldie, Kathy<BR><B>Sent:</B> Friday, October 16, 2009 10:16
AM<BR><B>To:</B> Pickering, John (NORBORD);
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: error linking
files<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Neither (subpofile is a
sub file I created from POfile – I wanted to take the po# and the poline from
the subpofile find the matching po & poline in pofil and change the dates (I
am tryingto use this in a qtp)<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">ACC
*SUBPOFIL LINK SPO TO PO OF POFIL &<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi"> LINK
SPOLINE TO POLINE OF POFIL ALIAS POFIL2</SPAN><SPAN
style="COLOR: #1f497d"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">OUTPUT
POFIL UPDATE<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi"> ITEM
POVPD FINAL sPOVPD<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi"> ITEM
POREQSTD FINAL XPOREQSTD<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi"> ITEM
POSDD FINAL SPOSDD<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi"> </SPAN><SPAN
style="FONT-SIZE: 12pt; COLOR: red; FONT-FAMILY: Courier">SET PROC LIM
170000</SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi"> GO<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">POFIL
TYPE SCALE
SCALE DEC PICTURE<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">*
PO
CHAR
X(10)<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">*
PN
CHAR
X(18)<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POREV
CHAR
X(2)<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
INTENTNO
NUM
0 0 0
^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">*
VNCODE
CHAR
X(10)<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POWO
CHAR
X(10)<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POOQ
NUM 2 2
2 ^^^^^^^^^^.^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POQI
NUM 2 2
2 ^^^^^^^^^^.^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POQS
NUM 2 2
2 ^^^^^^^^^^.^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POQRTVR
NUM 2 2
2 ^^^^^^^^^^.^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POQRTVC
NUM
2 2 2
^^^^^^^^^^.^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POQSCR
NUM 2 2
2 ^^^^^^^^^^.^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POQSD
NUM 2 2
2 ^^^^^^^^^^.^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POQSYSR
NUM 2 2
2 ^^^^^^^^^^.^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POUC
NUM 3 3
3 ^^^^^^^^^.^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
PUOM
CHAR
X(2)<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POCONV
NUM 3 3
3 ^^^^^^^^^.^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POLDD
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POVPD
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POREQSTD
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POSDD
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POMRPD
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POLADD
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POCHGD
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
PORCDD
NUM 0
0 0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
PORTVD
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POLSTAT
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POLCD
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POLTAX
NUM
0 0 0 ^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POSEQ
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
PONXTSEQ
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
PODEST
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POSOURCE
NUM 0 0
0 ^^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POIC
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POLNET
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POACCT
CHAR
X(24)<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POPA
CHAR
X(16)<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POCC
CHAR
X(6)<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POLTYP
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POBLIEN
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POLINE
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
PORFCUC
NUM 3 3
3 ^^^^^^^^^.^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POCOMM
CHAR
X(8)<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POWEIGHT
NUM
3 0 3
^^^^^^^^^.^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">
POTDELV
NUM 0 0
0 ^^^^^<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<DIV>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> Pickering, John
(NORBORD) [mailto:John.Pickering@norbord.com] <BR><B>Sent:</B> Friday, October
16, 2009 10:10 AM<BR><B>To:</B> Goldie, Kathy;
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: error linking
files<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Arial','sans-serif'">Is
POLINE an index or key in file POFIL?<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Arial','sans-serif'"><o:p> </o:p></SPAN></P>
<DIV>
<DIV class=MsoNormal style="MARGIN-LEFT: 0.5in; TEXT-ALIGN: center"
align=center><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'">
<HR align=center width="100%" SIZE=2>
</SPAN></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">
powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com
[mailto:powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com] <B>On
Behalf Of </B>Goldie, Kathy<BR><B>Sent:</B> Friday, October 16, 2009 11:09
AM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> error linking
files</SPAN><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'"><o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN
style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN
style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in">Trying to link and I use this
cmd and get this error<o:p></o:p></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">ACC *SUBPOFIL LINK SPO TO PO OF
POFIL &<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi"> LINK SPOLINE TO POLINE OF
POFIL ALIAS POFIL2</SPAN><o:p></o:p></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">Can't establish linkage to
POFIL2<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">What am I doing wrong – do I need a
special file equate?<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">Thank you in
advance<o:p></o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: r_ansi">Kathy</SPAN><o:p></o:p></P></DIV>The information in this e-mail and any attachments is confidential and may be subject to legal professional privilege. It is intended solely for the attention and use of the named addressee(s). If you are not the intended recipient, or person responsible for delivering this information to the intended recipient, please notify the sender immediately. Unless you are the intended recipient or his/her representative you are not authorised to, and must not, read, copy, distribute, use or retain this message or any part of it.
</BODY></HTML>