Previous Topic

Next Topic

Book Contents

Book Index

CTBDBVDL Parameters

The following parameters can be specified in the EXEC statement that invokes the CTBDBVDL JCL procedure. These parameters provide dynamic specification of source and destination file names:

Table 181 CTBDBVDL EXEC Parameters

Parameter

Description

DMOD

Prefix of the third qualifier of the name of the Database Variable Basic file

DVAR

Prefix of the third qualifier of the name of the Database Variable Generation file. Mandatory.

DGRP

Prefix of the third qualifier of the name of the Group file. Mandatory.

DELGR

Flag that indicates if the entire group is deleted. Valid values are:

  • Y (Yes) – Delete the entire group if no variables exist for this group.
  • N (No) – Do not delete the entire group. Default.

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

Table 182 CTBDBVDL SYSIN Parameters

Parameter

Description

GROUP

Group name (or prefix) of variables to be deleted. A group name prefix can be specified only if parameter VARIABLE contains an *.

Examples:

GROUP=INV Variables of group INV are deleted.

GROUP=INV* Variables of all groups that begin with INV (for example, INV, INVENTORY, INVESTMENTS) are deleted.

Note: GROUP=* cannot be specified.

VARIABLE

Variable name (or prefix) to be deleted

Note: Parameter VARIABLE can be specified only if ‘*' is not specified for parameter GROUP.

Example:

GROUP=INV VARIABLE=TOT
Variable TOT of group INV is deleted.

GROUP=INV VARIABLE=TOT*
Variables of group INV that begin with TOT (for example, TOT, TOTAL, TOT01, TOT02) are deleted.

Parent Topic

CTBDBVDL – Delete Variables or Groups from Variable or Group Files