error linking files

[Guy Werry]

Kathy,
 
There are two problems here:

*	
	POLINE is NOT a KEY, so you can't make that linkage, unless you
put it into a SELECT statement
*	
	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.

Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited. 


________________________________

From: powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com
[mailto:powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com] On Behalf
Of Goldie, Kathy
Sent: Friday, October 16, 2009 10:16 AM
To: Pickering, John (NORBORD); powerh-l at lists.sowder.com
Subject: RE: error linking files



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)

ACC *SUBPOFIL LINK SPO TO PO OF POFIL &

 LINK SPOLINE TO POLINE OF POFIL ALIAS POFIL2

OUTPUT POFIL UPDATE

 ITEM POVPD FINAL sPOVPD

 ITEM POREQSTD FINAL XPOREQSTD

 ITEM POSDD FINAL SPOSDD

 SET PROC LIM 170000

 GO

 

 

POFIL                                   TYPE SCALE SCALE  DEC PICTURE

* PO                                    CHAR                  X(10)

* PN                                    CHAR                  X(18)

  POREV                                 CHAR                  X(2)

  INTENTNO                              NUM     0     0    0  ^^^^^

* VNCODE                                CHAR                  X(10)

  POWO                                  CHAR                  X(10)

  POOQ                                  NUM     2     2    2
^^^^^^^^^^.^^

  POQI                                  NUM     2     2    2
^^^^^^^^^^.^^

  POQS                                  NUM     2     2    2
^^^^^^^^^^.^^

  POQRTVR                               NUM     2     2    2
^^^^^^^^^^.^^

  POQRTVC                               NUM     2     2    2
^^^^^^^^^^.^^

  POQSCR                                NUM     2     2    2
^^^^^^^^^^.^^

  POQSD                                 NUM     2     2    2
^^^^^^^^^^.^^

  POQSYSR                               NUM     2     2    2
^^^^^^^^^^.^^

  POUC                                  NUM     3     3    3
^^^^^^^^^.^^^

  PUOM                                  CHAR                  X(2)

  POCONV                                NUM     3     3    3
^^^^^^^^^.^^^

  POLDD                                 NUM     0     0    0  ^^^^^

  POVPD                                 NUM     0     0    0  ^^^^^

  POREQSTD                              NUM     0     0    0  ^^^^^

  POSDD                                 NUM     0     0    0  ^^^^^

  POMRPD                                NUM     0     0    0  ^^^^^

  POLADD                                NUM     0     0    0  ^^^^^

  POCHGD                                NUM     0     0    0  ^^^^^

  PORCDD                                NUM     0     0    0  ^^^^^

  PORTVD                                NUM     0     0    0  ^^^^^

  POLSTAT                               NUM     0     0    0  ^^^^^

  POLCD                                 NUM     0     0    0  ^^^^^

  POLTAX                                NUM     0     0    0  ^

  POSEQ                                 NUM     0     0    0  ^^^^^

  PONXTSEQ                              NUM     0     0    0  ^^^^^

  PODEST                                NUM     0     0    0  ^^^^^

  POSOURCE                              NUM     0     0    0  ^^^^^^

  POIC                                  NUM     0     0    0  ^^^^^

  POLNET                                NUM     0     0    0  ^^^^^

  POACCT                                CHAR                  X(24)

  POPA                                  CHAR                  X(16)

  POCC                                  CHAR                  X(6)

  POLTYP                                NUM     0     0    0  ^^^^^

  POBLIEN                               NUM     0     0    0  ^^^^^

  POLINE                                NUM     0     0    0  ^^^^^

  PORFCUC                               NUM     3     3    3
^^^^^^^^^.^^^

  POCOMM                                CHAR                  X(8)

  POWEIGHT                              NUM     3     0    3
^^^^^^^^^.^^^

  POTDELV                               NUM     0     0    0  ^^^^^

 

 

From: Pickering, John (NORBORD) [mailto:John.Pickering at norbord.com] 
Sent: Friday, October 16, 2009 10:10 AM
To: Goldie, Kathy; powerh-l at lists.sowder.com
Subject: RE: error linking files

 

Is POLINE an index or key in file POFIL?

 

________________________________

From: powerh-l-bounces+john.pickering=norbord.com at lists.sowder.com
[mailto:powerh-l-bounces+john.pickering=norbord.com at lists.sowder.com] On
Behalf Of Goldie, Kathy
Sent: Friday, October 16, 2009 11:09 AM
To: powerh-l at lists.sowder.com
Subject: error linking files

 

 

 

 

Trying to link  and I use this cmd and get this error

 

ACC *SUBPOFIL LINK SPO TO PO OF POFIL &

 LINK SPOLINE TO POLINE OF POFIL ALIAS POFIL2

 

Can't establish linkage to POFIL2

 

 

 

What am I doing wrong - do I need a special file equate?

 

Thank you in advance

 

Kathy


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20091016/3e34ea23/attachment-0001.htm