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

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
    253 Posts

    Re: new to iSeries

    ‏2012-09-12T07:48:09Z  
    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

    Re: new to iSeries

    ‏2012-09-12T08:34:12Z  
    • B.Hauser
    • ‏2012-09-12T07:48:09Z
    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
    Thank you Birgitta. I got the picture clear now... :-)