Filter
Top Products
38 IBM Sterling Connect:Direct for i5/OS User’s Guide
K enables the KQV logic trace.
D enables the all-purpose data dump.
H enables the FMH dump.
V enables the XDR dump.
P enables the CIPC dump.
*ALL enables all product traces.(L, S, F, C, X, K, D, H, V, and P)
*EXT enables all product traces plus two other traces. (TRCICF and TRCJOB)
*COMMON enables the most commonly used traces. (L, S, F, C, and H)
*NONE turns off all traces.
TSPACE(avgblk, type, primary, secondary, pdsblk, rlse, contig, round)
specifies the amount of storage to be allocated for new files on the destination node.
If you specify SPACE, the DISP of the destination file must be NEW. If you do not specify SPACE
and the DISP is NEW, space allocation defaults to the value obtained from the source file (unless a
TTYPE has been specified). The default allocation is in blocks and, if supplied with the ROUND
option, provides device-independent space allocation.
This parameter is required for all new non-VSAM files unless you have specified a type key that
includes a SPACE parameter.
avgblk defines the average blocksize.
type defines the space allocation. Valid options are:
CYL specifies that space is to be allocated by cylinder.
TRK specifies that space is to be allocated by track.
blk specifies that space is to be allocated by the average block length of the data and is the
default. The system computes the number of tracks to be allocated. If the subparameter ROUND
is also specified, the system allocates the space in cylinders. ROUND is preferred because
allocation is performed on cylinders in a device-independent manner. If no space information is
coded, allocation is in blocks, due to device dependencies.
primary specifies the primary allocation of storage in number of units.
secondary specifies the secondary allocation of storage in number of units.
pdsblk specifies the number of PDS directory blocks to be created in the file.
rlse specifies that the unused storage allocated to the output file be released. Valid values are *YES
and *NO.
contig specifies that the storage for the local allocation must be contiguous. Valid values are *YES
and *NO.
round specifies that the storage allocated by average block length is rounded to an integral number of
cylinders. Valid values are *YES and *NO.
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. The SQL parameter is used with the optional
Sterling Connect:Direct for z/OS SQL feature. This parameter is valid for Sterling Connect:Direct for
z/OS nodes only.
‘sql-statement’ defines the actual SQL statement to be processed.
‘DSN=data-set-name’ specifies the data set containing the SQL statement(s) to be processed.