The SELECT statement specifies filter criteria for selecting the registrations to be copied.
The following parameters are optional, but you must enter at least one to select registrations for copying:
DBID=
database_instance
the source database instance associated with the registrations to select. This value depends on the database type. For example, the database instance might be a DB2 subsystem ID or a database name. You can use the asterisk (*) wildcard character to select multiple instances.
The following entries are valid:
The full name of a specific instance. For example:
DBID=sample
Part of the instance name with the asterisk wildcard (*) to create a mask that matches one or more instances. For example:
DBID=sam*
The wildcard (*) only for all instances:
DBID=*
Default is the wildcard (*) only.
DBTYPE=
database_type
Specifies the source database type associated with the registrations to select.
Valid values are:
ADA
for Adabas.
AS4
for DB2 for i (i5/OS).
DB2
for DB2 for z/OS.
DCM
for Datacom.
IDM
for IDMS.
IMS
for IMS.
MSS
for Microsoft SQL Server.
MYS
for MySQL.
ORA
for Oracle.
PGS
for PostgreSQL.
UDB
for DB2 for Linux, UNIX, and Windows.
VSM
for VSAM.
REG_NAME=
registration_name
The name of the registration that you want to select for the copy operation. Use the registration name that was entered when the registration was created. You can use the asterisk (*) wildcard character to select multiple registrations.
The following entries are valid:
The full registration name. For example:
REG_NAME=capture1
Part of the registration name with the asterisk wildcard (*) to create a mask that matches one or more registrations. For example:
REG_NAME=prod*
The wildcard (*) only to select all registrations. For example: