does somebody sees an error in the following DDS for a LF:
Code:
A R MHSTRYS PFILE(MATUPDTEST/MHSTRY)
A MHSKEY10 10A I SST(MHSKEY 01 10)
A K MHSKEY10
A S
3 results in 0.0019 seconds.
-
CPD7948: Name of Key- or Select-Field not found in logical file
Hello,
does somebody sees an error in the following DDS for a LF:
... -
How do I duplicate Query/400 join type 3 with a join logical?
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... -
Need help
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