Cursusbeschrijving This 2,5 days classroom course teaches basic relational database theory, coding, creation, and maintenance of DB2 UDB for i physical and logical files. It teaches many techniques that, if implemented, will enhance the performance of applications using the database. This course does not discuss the use of SQL for database management.
Voorkennis
Students should be able to:
- Use PDM/SEU to enter source code into a source file
- Use PDM to create an i object from a source file member
- Explain the function of data description specifications (DDS) in defining files on the i
- Use data file utility (DFU) to maintain a physical file
These prerequisites can be met by successful completion of IBM i Programming Facilities Workshop (OL490).
Cursusdata
Data beschikbaar op aanvraag. Neem contact met ons op.
Meer informatie
This basic course is for persons who will be responsible for creating and maintaining a DB2 UDB for i database. It will also provide the necessary foundation for those persons intending to write application programs for DB2 UDB for i.
- Given a relational database design, code the DDS and create the physical and logical files necessary to implement a DB2 UDB for i relational database
- Describe the advantages of a field reference file, code the necessary DDS and create a field reference file
- Explain how the choices made while coding the DDS and creating the file affect the performance of the system and the programs using the files
- Understand the different ways to interface to DB2 UDB for i
- Describe the considerations for using DB2 UDB for i referential integrity and triggers