Learn how to code, create and maintain DB2 UDB for i physical and logical files using native Data Description Specifications (DDS) and Control Language (CL) commands. Build a DB2 UDB for i relational database foundation, if you intend to write application programs for the IBM i system, however the course does not address SQL implementation of DB2 UDB for i.

Learn many techniques that, if implemented, enhance the performance of applications using the database.

• 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
• Describe the considerations for using the DB2 UDB for i referential integrity and triggers

This is a basic course for individuals who create and maintain a DB2 UDB for i database.

Cours magistral dont 40 % du temps consacré aux travaux pratiques.

You must be able to:

• Use Program Development Manager (PDM) and Source Entry Utility (SEU) to enter source code into a source file
• Use PDM to create an IBM i object from a source file member
• Explain the function of DDS in defining files on the i
• Use Data File Utility (DFU) to maintain a physical file

• The relational database model
• Creating physical files
• Creating logical files
• Database performance considerations for application design
• Database maintenance
• DB2 UDB for i referential integrity
• DB2 UDB for i triggers
• The relational database model
• Creating physical files
• Creating logical files
• Database performance considerations for application design
• Database maintenance
• DB2 UDB for i referential integrity
• DB2 UDB for i triggers

La mise en oeuvre et l'exploitation de SQL/400, les procédures cataloguées, ainsi que l'ensemble des fonctionnalités de DB2 UDB sont traitées dans le cours OL38FR.

Prior to enrolling, IBM Employees must follow their Division/Department processes to obtain approval to attend this public training class. Failure to follow Division/Department approval processes may result in the IBM Employee being personally responsible for the class charges.

GBS practitioners that use the EViTA system for requesting external training should use that same process for this course. Go to the EViTA site to start this process: http://w3.ibm.com/services/gbs/evita/BCSVTEnrl.nsf

Once you enroll in a GTP class, you will receive a confirmation letter that should show:

The current GTP list price

The 20% discounted price available to IBMers. This is the price you will be invoiced for the class.