Filter
Top Products
Sending a File 27
CCSID(nnnnn) specifies the coded character set ID to use when creating IFS files. If no character set
ID is specified, the system default is used.
EORCHAR(xxxx) specifies the two-to four-digit hexadecimal symbol to identify the character to use
in text files as the end-of-record character, for example, EORCHAR(0A).
CODEPAGE(nnnnn,nnnnn) converts data from one code page to another. The supported
conversions are identified on the IBM Web site in the V5R1 Information Center, DB2 Universal
Database for iSeries SQL Reference, Appendix E. CODEPAGE() on Sterling Connect:Direct for
i5/OS relates to CODEPAGE() developed for the z/OS system, UNIX, and Microsoft Windows.
nnnnn identifies the IBM CCSID code page number to convert from and the IBM CCSID code
page number to convert to. If the FROM code page or TO code page is locale, the code page for
the locale where Sterling Connect:Direct is executing is used. For example, if
tosysopt(codepage(1208,locale)), then the FROM codepage is UTF-8 code page and the TO code
page is the local code page.
TYPE(FILE
|MBR|OBJ|SPLF) specifies the type of data to be sent. Define the type of data to be sent
as one of the following:
FILE
specifies that the file being copied is a physical database file.
MBR specifies that the object being copied is a member of a physical database file.
OBJ specifies that the data to be copied is in save file format.
SPLF specifies that the data to be copied is an i5/OS spooled output file.
For each type of file, you can specify certain additional TOSYSOPTS parameters.
If the receiving node is a Sterling Connect:Direct for i5/OS node, the following TOSYSOPTS
parameters are valid for TYPE(FILE) and TYPE(MBR) files:
RCDLEN(record-length) specifies the data length for each record in the file.
FILETYPE(*SRC
|*DATA) specifies the type of file to be created.
TEXT(‘text description’) specifies a text description to be associated with this member (and
file, if created). This description cannot exceed 50 characters and must be enclosed in single
quotes.
EXPDATE(expiration-date) specifies the date after which the new or replaced member cannot
be used. If EXPDATE is not specified, then the file does not have an expiration date.
MAXMBRS(number|*NOMAX
) specifies the maximum number of members a physical file
can contain.
SIZE(#-of-recs|incr-value #-of-incrs|*NOMAX) used when a new file is created for the file
received.
AUT(*CHANGE
|*ALL|*USE|*EXCLUDE) specifies the authority to be given to a user who
does not have specific authority to the file or member, is not on the authorization list, and whose
user group does not have specific authority to the file or member.
IGCDTA(*YES|*NO) specifies that DBCS support is installed on the destination i5/OS node
and the file being sent contains DBCS data.The following TOSYSOPTS parameters are valid for
TYPE(OBJ) files:
MAXRCDS(number|*NOMAX
) specifies the maximum number of records the save file (which
was created to hold the data received) can reach.
ASP(auxiliary-storage-pool) specifies the auxiliary storage pool from which the system
allocates storage for the save file.
TEXT(‘text description’) specifies a text description to be associated with this object. This
description cannot exceed 50 characters and must be enclosed in single quotes.
AUT(*EXCLUDE|*CHANGE|*ALL|*USE) specifies the authority to give to a user who does
not have specific authority to the object, is not on the authorization list, and whose user group
does not have specific authority to the object.