Using Referential Integrity This course is also available on CD-ROM
Presenter: Manta Technologies
Availability: Online SKU: 3592
Course Description: This course describes how to implement referential integrity in a DB2 UDB database. The course begins by describing the concept of referential integrity and discussing how it is implemented in a DB2 UDB database. Next, you will see how to define a referential constraint, the set of rules that defines the relationship between two files. The course then describes how to work with referential constraints and how to resolve a check pending situation.
The course ends by showing how an application can detect a constraint violation.
After completing this course, you should be able to: • Use and define referential integrity terminology • Name and define the various referential constraint rules • Name and describe the different types of physical file constraints • List the steps required to implement referential integrity • Identify the various referential constraint states • Define a unique or primary key constraint • Define a referential constraint • Display the constraint information for a file • Display a list of the records that caused a referential constrain to be marked as check pending • Change the status of a constraint • Delete a constraint • Describe the techniques that can be used in an RPG program to detect a constraint violation • Describe the techniques that can be used in a COBOL program to detect a constraint violation
Audience: This course is intended for programmers and application developers who will be creating physical file constraints and working with files for which constraints have been defined.
Prerequisites: This course assumes that you have a basic knowledge of OS/400 facilities. You can satisfy this prerequisite by successfully completing the Using an iSeries System series. It also assumes that you have a basic knowledge of DB2 UDB. You can satisfy this prerequisite by successfully completing the first course in the series, Introduction to DB2 UDB. Finally, it assumes you have a reading knowledge of either RPG IV or COBOL.
Course Outline: Introduction to Referential Integrity Defining Constraints Working with Constraints Detecting Constraint Violations in an Application
Course Details:
Length:
90 minutes
Format:
Online Learning
Publisher:
Manta
Using Referential Integrity This course is also available on CD-ROM
Using Referential Integrity
