CPD7948: Name of Key- or Select-Field not found in logical file

[Sascha]

Hello,
does somebody sees an error in the following DDS for a LF:

     A          R MHSTRYS                   PFILE(MATUPDTEST/MHSTRY)
     A            MHSKEY10      10A  I      SST(MHSKEY 01 10)
     A          K MHSKEY10
     A          S

...

[JSun]

I have a query that gives me the results I want using a join type 3 (unmatched records with primary file), and I want to create a join logical file that will give the same results.

Basically, both files contain order data. I want to join on order number and only include the records from...

[xo0627]

when i am running STRSQL to get records counts on our system, i noticed that the SQL running time with PFs is much shorter than LFs. This puzzles
me a lot. Could any of the experts help me to answer this question, thanks in advance.

waiting online

Xo