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:
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.
MAXMBRS(number*NOMAX) specifies the maximum number of members a physical file can contain.
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:
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