Create iSeries PF with multiple record formats

185 pts.
Tags:
DDS
iSeries
Physical File
How can I create an iseries PF with multiple record formats

Software/Hardware used:
iSeries V7R2M0

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you are creating the file using DDS,all you need to do is add another  “R”  record format name in the DDS.

Discuss This Question: 7  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.
  • Subhendu Sen
    Read this article, it can help to understand: http://search400.techtarget.com/answer/Create-multiple-record-formats
    89,080 pointsBadges:
    report
  • GregManzo
    Really? I always though you needed to create a separate Physical for each format and then create a Logical spanning all of them. The the *logical* has multiple formats, but not the physicals.
    1,690 pointsBadges:
    report
  • ToddN2000
    Yeah it's a weird concept. In my 35+ years in IT I have rarely seen a PF with more than one record format. I have seen more joined LF with multiple record formats than any other type.
    84,495 pointsBadges:
    report
  • NickHutcheson1
    One system I worked on had mulitple record format physicals with multiple members, and logicals over the physicals with multiple members.  A total nightmare.  Especially when the physicals all had to be recreated and their logicals and add all of the members back after a disk crash. I think it was called Pansofic. 
    1,485 pointsBadges:
    report
  • ToddN2000
    When databases start to get that involved the risk of problems rises. Unless you have very good documentation, or a good DBA,  it is very easy to corrupt a file(s) by accident. We have had situations where someone logged in under the wrong profile and created test logical files over production physical file.. In my opinion it is best to keep files and databases as simple as needed for the job.
    84,495 pointsBadges:
    report
  • GregManzo
    Agreed. There is a lot to be said for the KISS principle. :-)
    1,690 pointsBadges:
    report
  • TheRealRaven
    Trying to compile DDS for a PF that contains more than one 'R'ecord format will fail with message ID CPD7914, severity 30.

    Message . . . . :   File contains more than one record.                     
    Cause . . . . . :   A physical file or a join logical file must contain only one record.                                                               
    Recovery  . . . :   Change the file to contain only one record. Then try the request again.

    A simple DSPMSGD CPD7914 shows that text.

    Technically, a physical file can have only one format (in a relational database). If there is some weird reason that multiple formats are needed, create a 'program-described' file, perhaps even using IDDU if you have it, and treat each record in whatever way you choose to do the programming. Very much not recommended since there are so many better ways to accomplish whatever it is that needs to be done. (Better ways, and easier, and more maintainable, and just about everything else, which is why the practice was left behind decades ago.)
    21,845 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.

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

Following

Share this item with your network: