Filter
Top Products
Sending a Spool File 81
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
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).
Optional Parameters
The following parameters are optional. Unless otherwise noted, the parameters apply to all remote node
environments.
BLKSIZE(n|*CALC
)
specifies the blocksize value for the source file. This value must be a multiple of the file record size.
n specifies the block size of the file. This value must be a multiple of the record size. The valid range
is 1–32720
*CALC
indicates that the blocksize is calculated.
CHLVAL(*NORMAL| (channel#1 line#1) . . . (channel#12 line#12))
specifies the list of channel numbers with their assigned line numbers. Note that you must specify
CTLCHAR(*FCFC) for this to be a valid parameter.
*NORMAL indicates that channel 1 causes a skip to the next line, and channel 12 causes a skip to the
overflow line (OVERFLOW parameter). Channels 2–11 cause a space-one-line operation.
(channel#1 line#1) . . . (channel#12 line#12) specifies channel number and line number. Any
combination of channel numbers, 1–12, is specified along with a line number to be assigned to that
channel number. Valid line numbers range from 1–255. If no line number is assigned to a channel
number and that channel number is found in the data, a default of space-one-line before printing is
taken. You can specify each channel and line number once.
CKPTINV(n)
Number of bytes, from 1K to 2 gigabytes, to send or receive before taking a checkpoint. The format is
nnnnnnn, nnnnnnK, or nnnnnnM, where K specifies thousands of bytes and M specifies millions of
bytes. A value of 0 specifies no checkpoint restart Sterling Connect:Direct for i5/OS uses the value
you specify, rounded up to the nearest record boundary, to determine when to take a checkpoint. If
you specify a value between 1 and 1023, the value becomes 1024 or 1K.
A checkpoint interval specified here overrides the system-wide default value in the initialization
parameters.
CLASS(n)
determines the node-to-node session on which a Sterling Connect:Direct operation can execute. The
CLASS is a number from 1–255. If you do not specify the CLASS parameter, it defaults to the
number of maximum sessions defined in the communications environment mode description.
Note: The CLASS parameter is not used by Sterling Connect:Direct for i5/OS.