[Bulk] RE: [Bulk] error linking files

[Ken Langendock]

I think you want to do this;

 

ACCESS *SUBPOFIL &

  LINK SPO OF SUBPOFIL &

    TO PO &

    OF POFIL 

 

 SELECT POFIL &

     IF POLINE OF POFIL EQ SPOLINE OF SUBPOFIL

 

OUTPUT POFIL UPDATE

 ITEM POVPD FINAL sPOVPD

 ITEM POREQSTD FINAL XPOREQSTD

 ITEM POSDD FINAL SPOSDD

 SET PROC LIM 170000

 GO

 

 

From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Goldie, Kathy
Sent: October 16, 2009 11:17 AM
To: Ken at Langendock.com; powerh-l at lists.sowder.com
Subject: [Bulk] RE: [Bulk] error linking files

 

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  ^^^^^

 

 

SUBPOFIL                                TYPE SCALE SCALE  DEC PICTURE

  SPO                                   CHAR                  X(10)

  SPOLINE                               NUM     0     0    0  ^^^^^^

  SPOVPD                                NUM     0     0    0  ^^^^^^

  XPOREQSTD                             NUM     0     0    0  ^^^^^^

  SPOSDD                                NUM     0     0    0  ^^^^^^

  SPOMRPD                               NUM     0     0    0  ^^^^^^

 

 

 

 

From: Ken Langendock [mailto:ken.langendock at rogers.com] 
Sent: Friday, October 16, 2009 10:15 AM
To: Goldie, Kathy; powerh-l at lists.sowder.com
Subject: RE: [Bulk] error linking files

 

I think you need to send the PDL for the two files for us to be able to give
you an good answer. Or at least an excerpt showing the primary indexes.

 

Ken

 

From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Goldie, Kathy
Sent: October 16, 2009 11:09 AM
To: powerh-l at lists.sowder.com
Subject: [Bulk] 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20091016/49816e3e/attachment-0001.htm