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
IDL
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: