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

TYPE(FILEMBROBJSPLF) specifies the type of data structure to be created. You must define the data structure to be created as one of the following:

FILE specifies that the file being created is a physical database file.

MBR specifies that the member being created is a member of a physical database file. OBJ specifies that the file being created is in save file format.

SPLF specifies that the data is copied to an i5/OS spooled output file. The default is TYPE(FILE).

For each type, you can specify certain additional TOSYSOPTS parameters.

The following subparameters 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. Use this parameter whenever a file is 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)is 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.

The following parameters are valid for TYPE(OBJ) files:

MAXRCDS(number-of-records*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. Valid values range from 1–16. The default is 1.

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 be given 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.

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 codepage 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 code page is UTF-8 code page and the TO code page is the local code page.

Page 52
Image 52
IBM CDI5UG1107 manual IBM Sterling ConnectDirect for i5/OS User’s Guide