The CTDGIDB2 member in the CTD PARM library includes a list of all paths that are handled by the Global Index Database, and defines the relationship between Control‑V Index paths and DB2 tables. This member contains the path number and the name of DB2 table storing information for this path. Subsequent lines contain Control‑V index names and corresponding field names in the DB2 table.
CTDGIDB2 member statements are described in the following table, and an example is provided below:
Table 171 CTDGIDB2 Member Statements
Statement |
Description |
---|---|
DSN=DSN_NAME |
DB2 Subsystem name |
PLAN=PLAN_NAME |
DB2 application plan name for the CTD DB2 interface module. This application plan should be bound from the DBRL member CTDGID supplied in the IOA SAMPLE library. |
The two preceding statements are obligatory and should be coded only once on the top of the member. The PATH, TABLE, and FIELD statements shown below should be coded for each Global Index path. The REKEY statement is optional. The END line, as shown in the code example that follows this table, indicates the conclusion of the entire member statement. |
|
PATH=NNN or PATH=NNN+ |
Number of the path. Each path should have a unique number. The ‘+’ sign should follow the number if this PATH must be loaded while running a decollation mission. |
TABLE=TABLE_NAME |
DB2 table name containing index values and report keys of the index path. This statement can be specified more than once if data for this path is kept in more than one table. |
FIELD= |
This statement should be coded for each index field in the path. In this statement
|
REPKEY= |
Name of the report key field in the DB2 table. Optional. Default REP_KEY. |
END |
Last statement in the member. |
Figure 63 CTDGIDB2 Member Statement Example
DSN=DSN1 DB2 SUBSYSTEM NAME
PLAN=CTDGIPL6 DB2 APPLICATION NAME
PATH=001 PATH NUMBER
TABLE=CTD.GIRAD DB2 TABLE NAME
FIELD=(ACCOUNT,ACCOUNT,10) INDEX LEVEL 1 FIELD
REPKEY=REP_KEY REPORT KEY
PATH=002 PATH NUMBER
TABLE=CTD.GIRAD DB2 TABLE NAME
FIELD=(ACCOUNT,ACCOUNT,10) INDEX LEVEL 1 FIELD
FIELD=(DATE,DATE_,8) INDEX LEVEL 2 FIELD
REPKEY=REP_KEY REPORT KEY
PATH=003 PATH NUMBER
TABLE=CTD.GIRAN DB2 TABLE NAME
FIELD=(ACCOUNT,ACCOUNT,10) INDEX LEVEL 1 FIELD
FIELD=(NAME,NAME,15) INDEX LEVEL 2 FIELD
REPKEY=REP_KEY REPORT KEY
PATH=004+ PATH NUMBER
TABLE=CTD.GIRDN08 DB2 TABLE 1 NAME
TABLE=CTD.GIRDN07 DB2 TABLE 2 NAME
TABLE=CTD.GIRDN06 DB2 TABLE 3 NAME
FIELD=(KUNDNR,KUNDNR,9) INDEX LEVEL 1 FIELD
REPKEY=REP_KEY REPORT KEY
PATH=005 PATH NUMBER
TABLE=CTD.DEP_TEAM_ACCNT DB2 TABLE NAME
FIELD=(DEPARTMENT,DEPARTMENT,3),CTD.DEP+ INDEX LEVEL 1 FIELD
FIELD=(TEAM,TEAM,2),CTD.DEP_TEAM+ INDEX LEVEL 2 FIELD
FIELD=(ACCNT,ACCOUNT,9) INDEX LEVEL 3 FIELD
REPKEY=REP_KEY REPORT KEY
PATH=006 PATH NUMBER
FIELD=(DEPARTMENT,DEPARTMENT,3),CTD.DEP INDEX LEVEL 1 FIELD
FIELD=(TEAM,TEAM,2),CTD.DEP_TEAM+ INDEX LEVEL 2 FIELD
REPKEY=REP_KEY REPORT KEY
PATH=007 PATH NUMBER
TABLE=CTD.GIRJAR DB2 TABLE NAME
FIELD=(JOBNAME,JOBNAME,45) INDEX LEVEL 1 FIELD
REPKEY=REP_KEY REPORT KEY
END
Parent Topic |