Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2007

    Unanswered: Physical file vs SQL Table

    Can anybody point me to some documentation that explains in detail what is the difference (on an AS400 / iSeries system) between a physical file (created through DDS) and a table (created through SQL).
    I have read this post: and the definitions here:
    and I understand they are both a physical file but I take it there is more to it than just that. I would like to get in-depth information on this matter.

  2. #2
    Join Date
    Sep 2011

    IBM link

    I have found one nice PDF link yesterday while searching for same yesterday. But it talks more from performance perspective

    see if this helps.

  3. #3
    Join Date
    May 2003
    One way to look at is that IBM just put a SQL front end on their native iSeries (AS/400) file system, as you can access them natively or via SQL. This is fundamentally different than other DB2 products (DB2 LUW, DB2 z/OS, etc.) which were built from the ground up as relational databases.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts