how to create multiple record format in logical file?
SIR,
I HAVE 2 PF'S. PF11 AND PF26.
PF11 PF26
NAME ACCOUNTNO
CLASS SALARY
ROLL DEPTARTMENT
K NAME K ACCOUNTNO
001.00 R REC PFILE(PF11) 120711
001.01 K NAME 120803
001.02 R REC1 PFILE(PF26) 120803
001.03 K ACCOUNTNO 120803
002.00 K SALARY 120803
BUT IT IS GIVING ME ERROR DURING 14 COMPILATION .
Errors in DDS not allowed with specified GENLVL.
File PF12 not created in library.
Software/Hardware used:
SOFTWARE
Software/Hardware used:
SOFTWARE
ASKED:
August 3, 2012 9:23 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
What was the error?
We can guess what it was, but you really need to tell us. I suspect that your keys don’t match between the record formats.
Why are you creating a mutli-format LF? That’s a very old and essentially obsolete feature.
Tom
Think of your data as a spreadsheet with rows for each row of each file. Sort the spreadsheet on Column A. Can you “read” the first two lines and do the process you had in mind? What data from each field would you put in column A so a sort on it gets you data sets. Once you’ve resolved that, the first key then consider putting data from only one of the files in column b so that when you sort on A and B the data is properly grouped and ordered for your task. A and B represent your two keys.Phil
And since you are an SQL fan, you should know .. these don’t SQL.Phil
and since you asked about query/400 – you’ll get one format at a time in query/400.