IBM CDI5UG1107 manual Receiving a File

Receiving a File 51

TEXTFILE(*YES*NO) specifies that the file being sent is a text file.

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

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

MBR specifies that the member 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 in i5/OS spooled output format.

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 fmsysopts(codepage(locale,1208)), then the FROM code page is the code page for the locale and the TO code page is UTF-8.

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).

ALWNULL(Y) specifies if NULLS characters will be processed when sending DB2 files.

TOSYSOPTS(‘ DECMPR(*YES*NO) EXITCMD(valid i5/OS command) FAILCMD(valid i5/OS command) TYPE(FILEMBROBJSPLF) XTRAN(table-name) [XTRANLSO(so-code) XTRANLSI(si-code)XTRANLDATA(MIXEDDBCS)] CCSID(nnnnn)

EORCHAR(xxxx)

’)

specifies system operation parameters at the local node (i5/OS). The maximum number of characters permitted for TOSYSOPTS is 2K.

DECMPR(*YES*NO) specifies whether the local Sterling Connect:Direct is to decompress the received file. DECMPR(*NO) instructs the local system to place the received data in a database file without decompressing it.

Note: Ensure that the destination file contains no members before you receive a file with DECMPR(*NO) specified.

EXITCMD(valid i5/OS command) specifies a command to be executed only if the copy process is successful.

FAILCMD(valid i5/OS command) specifies a command to be executed only if the copy process is not successful.