CTBDBVCP Parameters

The following parameters can be specified in the EXEC statement that invokes the CTBDBVCP JCL procedure. These parameters dynamically specify the prefix of the third qualifier for the source and destination files listed below:

Table 178 CTBDBVCP EXEC Parameters

Parameter	Description
DIMOD	Source (input) Database Variable Basic Data file
DIVAR	Source (input) Database Variable Generation Data file
DIGRP	Source (input) Group file
DIGRP	Note: At least one of the above parameters must be specified. For each input file specified, the parameter (below) for the corresponding output file must also be specified.
DOMOD	Destination (output) Database Variable Basic file
DOVAR	Destination (output) Database Variable Generation file
DOGRP	Destination (output) Group file
REPLACE	Flag that indicates if the source variable overwrites an existing variable of the same name in the target. Optional. YES – Overwrite the target variable. Default. NO – Do not overwrite the target variable.
COPY	Flag that indicates whether entire records or only variables are copied. Optional. YES – Copy entire records from the Group file. NO – Copy only variables. Default.

Parameters can also be supplied using DD statement SYSIN. Only one parameter can be specified on each line.

Table 179 CTBDBVCP SYSIN Parameters

Parameter	Description
GROUP	Group name (or prefix) of variables to be copied. Mandatory. A group name prefix can be specified only if parameter VARIABLE contains an . Examples:* INV Variables of group INV are copied. Mandatory. INV* Variables of all groups that begin with INV (for example, INV, INVENTORY, INVESTMENTS) are copied.
GROUP	Note: Parameter GROUP can be specified only if ‘*’ is specified in parameter VARIABLE.
VARIABLE	Variable name (or prefix) to be copied. Examples: GROUP=INV VARIABLE=TOT Variable TOT of group INV is copied. GROUP=INV VARIABLE=TOT* Variables of group INV that begin with TOT (for example, TOT, TOTAL, TOT01, TOT02) are copied.
NUMGEN	Number of generations to be created for the variable during the copy. If not specified, the number matches the source variable’s number of generations. Do not specify more than the number of existing generations.
FROMGEN	Most recent generation to copy from the source to the target. If FROMGEN is not specified, Control-M/Analyzer begins copying with the current (most recent) source generation.
TOGEN	Oldest generation to copy from the source to the target. If TOGEN is not specified, Control-M/Analyzer. Copies successively older generations until the number of generations copied equals the existing value of TOGEN – FROMGEN + 1. Examples: GROUP=INV VARIABLE=TOT NUMGEN=20 FROMGEN=5 TOGEN=10 Assume the source variable has at least 10 generations. The target variable can have a maximum of 20 generations. The first six generations of the target variable contain the values of the 5th through 10th generations of the source variable.

Parent Topic

CTBDBVCP – Copy Variables or Groups to another File