IBM CDI5UG1107 manual Tvol*Yes*No

90IBM Sterling Connect:Direct for i5/OS User’s Guide

TSQL(sql-statementDSN=data-set-name)

defines the SQL statement to be processed against the database identified by the DBPARMS parameter or the DSN containing the SQL statements(s). The SQL parameter is used with the optional Sterling Connect:Direct SQL feature. This parameter is valid for z/OS nodes only.

sql-statementdefines the actual SQL statement to be processed.

data-set-namespecifies the data set containing the SQL statement or statements to be processed.

TTYPE(name)

specifies the entry name of the type defaults file on the remote node that contains the default file attributes used to allocate the destination file. TTYPE is required only if sending to a MS-DOS node.

TUNIT(unit-name)

specifies the unit address, device type, or user-assigned group name where the file resides or will reside. For SAM-to-SAM copies where the destination file is new and the UNIT parameter is not coded, the device type from the source file is used. For VSE nodes, you must specify either this parameter or TVOL.

Specify a unit-count to allow additional units to be allocated if required, or specify P to allocate the same number of units as volumes and then parallel mount the volumes.

TVOL(*YES*NO)

specifies the volume serial number(s) containing the file and optional processing associated with the file. If TVOL is not specified, the file must be cataloged. For VSE nodes, you must specify either this parameter or TUNIT.

private specifies allocation of an output file only if the volume is specifically requested and is used for direct access storage devices only. Valid values are *YES and *NO.

volcount specifies the maximum number of volumes required by an output file.

ser identifies by serial number the volumes where the output file resides or will reside.

TVOLREF(data-set-name)

allows you to place a data set on the same volume as the referenced data set. It must be cataloged on the system where it is referenced. This parameter is valid for z/OS nodes only.

TVSAMCAT(dsn,vmid,pwd,accmode,cuu)

specifies the catalog for the VSAM file to be copied. This parameter is required only if using a catalog other than the master catalog. This parameter is valid for VSE nodes only.

dsn specifies the filename of the VSAM catalog containing the file to be copied. The maximum length is 44 characters.

vmid specifies the owner ID for the VSAM minidisk where the file is located. The maximum length is eight characters.

pwd specifies the appropriate password for the VSAM minidisk where the file is located. The maximum length is eight characters.

accmode specifies the link access mode. Valid access modes are NULL, W (primary read/write access), M (primary multiple access), and MW (primary multiple access; alternate read/write only access).

cuu specifies the virtual address of the disk where the VSAM file is located. Any three-digit number is valid.