The chapters in this part describe in detail how to set up any AS/400* database file. This includes describing database files and access paths to the system and the different methods that can be used. The ways that your programs use these file descriptions and the differences between using data that is described in a separate file or in the program itself is also discussed.
This part includes a chapter with guidelines for describing and creating logical files. This includes information on describing logical file record formats and different types of field use using data description specifications (DDS). Also information is included on describing access paths using DDS as well as using access paths that already exist in the system. Information on defining logical file members to separate the data into logical groups is also included in this chapter.
A section on join logical files includes considerations for using join logical files, including examples on how to join physical files and the different ways physical files can be joined. Information on performance, integrity, and a summary of rules for join logical files is also included.
There is a chapter on database security in this part which includes information on security functions such as file security, public authority, restricting the ability to change or delete any data in a file, and using logical files to secure data. The different types of authority that can be granted to a user for a database file and the types of authorities you can grant to physical files are also included.