This event has ended. Visit the official site or create your own event on Sched.

Talarna lägger upp sessionerna själva och vi har påminnt dem om att göra det. 
Saknar ni någon kontakta gärna talarna direkt själva eller maila styrelsen.

Back To Schedule
Monday, October 16 • 15:00 - 15:45
Logical files, indexes and viewes - Don't get confused

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
Abstract: Long time ago, database objects were defined only with DDS (Data Description
Specifications). Data access occurred with native I/O through DDS described (keyed)
physical and logical files. But native I/O is only used in conjunction with RPG and COBOL.
DDS is only known on the IBM i and furthermore stabilized since a few releases. The rest of
the world uses SQL which also has become the strategical product for IBM for accessing and
database data and creating database objects. While DDS provides only a single type of
logical files, with SQL we are faced with two different types, respectively indexes and views.
As far as good! But … Do we really need to move completely to SQL? What is the difference
between these types of logical files? Which type of logical file has to be used in what
situation? … And finally what about native I/O?
Learning Objectives:
In this session the differences between the logical file types are explained. You’ll learn how
to move business logic into the database by generating SQL views. It will be explained why
SQL needs first and foremost access paths, either in SQL indexes or keyed logical files.
You’ll discover that even though an SQL index cannot be specified in an SQL statement, an
SQL index can be used in conjunction with native I/O like any DDS described keyed logical
Audience: IBM i developers, database administrators and everybody who has to access data located in
tables or physical files. This session is also important for companies and the appropriate
responsible persons who plan to modernize their applications and database.

avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →

Monday October 16, 2017 15:00 - 15:45 CEST