Topic
2 replies Latest Post - ‏2012-09-12T08:34:12Z by bijunator
bijunator
bijunator
2 Posts
ACCEPTED ANSWER

Pinned topic new to iSeries

‏2012-09-12T05:55:18Z |
I am an Oracle guy. Recently got involved in a system consisting of a wide variety of databases. Hence, got into learning iSeries.
Please help me understand few things --
What are physical and logical files?
Can they be considered equivalent to Create table and Create View DDLs in Oracle?
Or is the physical file equivalent to datafile in Oracle?
I am sorry if I am trying to learn by comparison but I am rather trying to learn things in a language familiar to me. Thanks for your patience...
Updated on 2012-09-12T08:34:12Z at 2012-09-12T08:34:12Z by bijunator
  • B.Hauser
    B.Hauser
    250 Posts
    ACCEPTED ANSWER

    Re: new to iSeries

    ‏2012-09-12T07:48:09Z  in response to bijunator
    An physical file is an SQL Table and can be created with the CREATE TABLE SQL command.
    An logical file can either be a view or an index, i.e. Field selections, Joins, Select/omit clauses (something like Where conditions) and Key Fields (something like the order by clause) are allowed.
    The equivalent for an unkeyed logical file is a view.
    The equivalent for a keyed logical file is an index.

    For more information you may check the IBM i information center - Database
    Link: http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=%2Frzahg%2Frzahgdb.htm

    Birgitta
    • bijunator
      bijunator
      2 Posts
      ACCEPTED ANSWER

      Re: new to iSeries

      ‏2012-09-12T08:34:12Z  in response to B.Hauser
      Thank you Birgitta. I got the picture clear now... :-)