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.

nnnnnidentifies 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(FILEMBROBJSPLF) 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-recsincr-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.

Page 27
Image 27
IBM CDI5UG1107 manual Sending a File