CICS VSAM Transparency for z/OS, Version 1.2


DB2 secondary tables

When a START BROWSE for VSAM01 in Figure 1 specifies a key which does exist, CICS® VT invokes MYFBE. The tables accessed by your FBE and IRD are referred to as secondary tables. MYFBE uses the DB2_RECORD_TYPE column value to decide which secondary to access. It also uses both key columns from the primary table to access the appropriate row in the secondary table.

This means that the primary key columns in the primary table must exist in each secondary table. The primary table is effectively the parent of the secondary tables. You should enforce this relationship using DB2® referential integrity.



Concept topic


Last updated: February 8, 2013 20:44:3