AS/400: Difference between member and record in physical file

450 pts.
Tags:
AS 400
AS/400 physical file
Difference between member and a record in a physical file? I am getting confused some one please explain? Source physical file vs physical file?
1

Answer Wiki

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

A source physical (CRTSRCPF) holds your program source code in individual members for each program. A regular physical (CRTPF or via DDS) holds your data an may contain 1 or multiple members. 

Discuss This Question: 3  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.
  • azohawk

    A member is a somehow unique collection of data that is common in a a file. In a source physical file: each member represents the code for an object. In data files I have encountered members to represent a variety of things. Some that I have found: Each division, or store in the company has a member, a work file may have a member for each user, a transaction file may have a member for each day, even different members for test and production (not recommended).

    Is there a reason to segment out the data? Does separate members make sense as the best way to segment out the data? Normally, when looking at the data in a member, one does not see data in the other members (there are ways around this limitation). I have encountered situations where multiple data file members were use effectively and made life easier, other times they were used and didn't make sense and were difficult to use.

    A record is just a row of data within the member. A record is composed of one or more fields (columns).

    4,055 pointsBadges:
    report
  • GregManzo
    Here is an analogy for you: Think Excel spreadsheet, it's still a single file. A Record is a row in the s/sheet, the record layout defines the columns in each row. A Member is like adding another tab to the s/sheet with the proviso that all the columns are the same as the original tab.
    A Source file is a multi-tab sheet with 3 specific columns: Line#, Date, Source code. Each program's source code goes in it's own tab.
    2,960 pointsBadges:
    report
  • TheRealRaven
    A database file may contain zero, one or more members. A member may contain zero, one or more records. (A SQL table is restricted to a single member since SQL has no concept of "member".) A record is a different name for a row in a table.
    35,130 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: