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

    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: http://www.dbforums.com/showthread.php?t=1189514 and the definitions here: http://publib.boulder.ibm.com/iserie...tm#HDRXDBTERMS
    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.
    Thanks

  2. #2
    Join Date
    Sep 2011
    Posts
    1

    IBM link

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

    http://www-03.ibm.com/systems/resour...ce_DDS_SQL.pdf

    see if this helps.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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
  •