how to create multiple record format in logical file?

420 pts.
Tags:
AS/400
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • philpl1jb
    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
    50,860 pointsBadges:
    report
  • philpl1jb
    And since you are an SQL fan, you should know .. these don't SQL.Phil
    50,860 pointsBadges:
    report
  • philpl1jb
    and since you asked about query/400 - you'll get one format at a time in query/400.
    50,860 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following