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...
B.Hauser 1000007U1D287 Posts
Re: new to iSeries2012-09-12T07:48:09ZThis is the accepted answer. This is the accepted answer.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