How are DB2 files different from Physical files in AS/400?

85 pts.
Tags:
AS/400 DB2
AS400 Command
Physical File
May i know how database tables are different from Physical files in as400
0

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.

Discuss This Question: 2  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.
  • philpl1jb

    In general they are the same.

    Differences:

    AS/400 Physical Files can have multiple members.

    54,090 pointsBadges:
    report
  • TheRealRaven
    All tables are physical files, but many physical files are not tables. In general, a SQL table is created with DDL. A physical file created outside of SQL may be manipulated as a table, but it won't be identified as a "table" in its file object header.

    The major difference is that a table can only have a single member as philpl1jb. Other potential differences are that some column data types can only be defined in tables, e.g., BLOBs may be in tables but not in basic PFs. Since tables are PFs, BLOBs and other SQL data types obviously are possible in PFs; but only SQL DDL provides a way to define them. Therefore only "tables" ever have such columns.
    36,035 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: