Filter
Top Products
90 IBM Sterling Connect:Direct for i5/OS User’s Guide
TSQL(sql-statement|DSN=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-statement defines the actual SQL statement to be processed.
data-set-name specifies 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.