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...
This topic has been locked.
2 replies Latest Post - 2012-09-12T08:34:12Z by bijunator
Pinned topic new to iSeries
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-09-12T08:34:12Z at 2012-09-12T08:34:12Z by bijunator
B.Hauser 1000007U1D250 PostsACCEPTED ANSWER
Re: new to iSeries2012-09-12T07:48:09Z in response to bijunatorAn 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