Filter
Top Products
52 IBM Sterling Connect:Direct for i5/OS User’s Guide
TYPE(FILE|MBR|OBJ|SPLF) 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-recs|incr-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.
nnnnn identifies 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.