HELP: Default values to simplify row specifications or automatic write TYPE: OBJECT SYNTAX: DEFAULTS(TYPE=BINARY/STRING/INTEGER/FLOAT,VARFMT=PLENPTR/ALENPTR/PPTRLEN/APTRLEN/PFLGLENPTR/PPTRLENFLG,CCSID='str'/DEFAULT/ASCII/EBCDIC/SYSTEM/LOCAL,SEPCHR[num/COMMA/COLON/SEMICOLON/TABULATOR/BLANK...],FLDCHR=num/QUOTATION/APOSTROPHE/GRAVEACCENT/PARENTHESES/RBRACKETS/SBRACKETS/BRACES/CBRACKETS/ABRACKETS,FLDMTD=ALWAYS/IFREQ/NONE,RECDLM=HOST/BIN/TXT/NL/USS/LF/UNIX/CR/OLDMAC/CRLF/WINDOWS/DLM/SYSTEM,NOHDLN,LENFLD=L4I/L4X/B4I/B4X/S4I/S4X/HLI/HLX/HBI/HBX/HSI/HSX/L2I/L2X/B2I/B2X/S2I/S2X/S1I/S1X/D1I/D2I/D3I/D4I/D5I/D6I/D7I/D8I/D9I/D0I/D1X/D2X/D3X/D4X/D5X/D6X/D7X/D8X/D9X/D0X,ELMDLM='bin'/CR-ASCII/LF-ASCII/NL-ASCII/CRLF-ASCII/CR-EBCDIC/LF-EBCDIC/NL-EBCDIC/CRLF-EBCDIC/CR-UTF08/LF-UTF08/NL-UTF08/CRLF-UTF08/CR-UTF16BE/LF-UTF16BE/NL-UTF16BE/CRLF-UTF16BE/CR-UTF16LE/LF-UTF16LE/NL-UTF16LE/CRLF-UTF16LE/CR-UTF32BE/LF-UTF32BE/NL-UTF32BE/CRLF-UTF32BE/CR-UTF32LE/LF-UTF32LE/NL-UTF32LE/CRLF-UTF32LE,FIXLEN=num,PADBYT=num,ENCODE/DECODE=OFF/BASE16/BASE32/BASE64,INTFMT=BIN/BCD/STR,FLTFMT=BIN/BCD/STR,INTVAL='str',FLTVAL='str',SIGMOD=IFNEGATIVE/SPACEIFPOSITIVE/PLUSIFPOSITIVE,INTBAS=num/BIN/B02/OCT/B08/DEC/B10/HEX/B16,INTCAS=UPPER/LOWER,FRASEP=SYSTEM/PERIOD/COMMA/APOSTROPHE,FLTSIG,INTSIG,ENDIAN=SYSTEM/BIG/LITTLE/LOCAL,INTWID=num/W08/W16/W32/W64,FLTWID=num/W32/W64,FLTTYP=SYSTEM,BCDTYP=UNPACKED/PACKED/ZONED,INTDIG=num,FRADIG=num,FROUND[=AWAYFROMZERO/NEAREST/TOWARDZERO/ERROR],CASMOD=UPPER/LOWER/FOLD/SUPPER/SLOWER/USRTAB,CHRMOD=STOP/IGNORE/SUBSTITUTE/IDENTITY/TRANSLIT,SUBCHR[num/SYSTEM...],SYSTAB=ICONV,USRTAB='str'/NPAS/SEPA/DELA/DLAX,WITSPC=PRESERVE/REPLACE/COLLAPSE/REMOVE/TRAILING/LEADING/BOTH/NUMBER,ONEMAP,CMBFRM=NFD/NFC/AUTO/ON/OFF,XMLSCM=STRUCTURED/UNSTRUCTURED,XMLNS[()...],VALUE='str',USENID,USEINTEID,USEFLTEID,NOESCP,NOCHECK/NOCHEK/NOCHK,LINEFD=num,INDSIZE=num,INDCHAR/INDCHR=SPACE/TABULATOR,COMMENT='str',ALIGN=num,SYSTEM,TLRCLS,FLATTX)
Default values can be set for many values that would otherwise need to be specified for every single column. By setting defaults via this object, the values set here apply to all rows/columns which are defined within the same table object. The defaults set here can be overridden by specifying other values for the respective columns parameters.
The SYSTEM switch can be used to ensure that everything is written in the system-specific representation. For example, length fields, binary integers and floats are written in system endianness, all strings are in local character set (encoding) and the system delimiters are used.
NUMBER: TYPE=BINARY/STRING/INTEGER/FLOAT - Default data type used for conversion [NONE]
BINARY - Write binary data
STRING - Write a string data type
INTEGER - Write a integer value
FLOAT - Write a fractional numbers
NUMBER: SEPCHR[num/COMMA/COLON/SEMICOLON/TABULATOR/BLANK...] - Default separator character as Unicode codepoint [COMMA]
COMMA - Comma separated (default)
COLON - Separated by colon (':')
SEMICOLON - Separated by semicolon (';')
TABULATOR - Separated by tabulator (x'0009')
BLANK - Separated by blank (x'0020')
NUMBER: FLDCHR=num/QUOTATION/APOSTROPHE/GRAVEACCENT/PARENTHESES/RBRACKETS/SBRACKETS/BRACES/CBRACKETS/ABRACKETS - Default field enclosing character as Unicode codepoint [DQM]
QUOTATION - Quotation mark as enclosing character
APOSTROPHE - Apostrophe as enclosing character
GRAVEACCENT - Grave accent as enclosing character
PARENTHESES - Round brackets as enclosing character
RBRACKETS - Round brackets as enclosing character
SBRACKETS - Square brackets as enclosing character
BRACES - Curly brackets as enclosing character
CBRACKETS - Curly brackets as enclosing character
ABRACKETS - Angle brackets as enclosing character
NUMBER: FLDMTD=ALWAYS/IFREQ/NONE - Default method for field enclosing character [ALWAYS]
ALWAYS - Use always field enclosing characters
IFREQ - Use field enclosing characters only if required
NONE - Don't use field enclosing characters
NUMBER: RECDLM=HOST/BIN/TXT/NL/USS/LF/UNIX/CR/OLDMAC/CRLF/WINDOWS/DLM/SYSTEM - Define default record delimiter for automatic write [auto]
HOST - Adds no delimiter (HOST)
BIN - Adds no delimiter (HOST)
TXT - Adds the system specific delimiter (DEFAULT)
NL - Adds delimiter new line (USS)
USS - Adds delimiter for USS (new line)
LF - Adds delimiter line feed (UNIX)
UNIX - Adds delimiter for UNIX (line feed)
CR - Adds delimiter carriage return (MAC)
OLDMAC - Adds delimiter for old MACs (carriage return)
CRLF - Adds delimiter carriage return line feed (WIN)
WINDOWS - Adds delimiter for WINDOWS (carriage return line feed)
DLM - Adds the system specific delimiter (DEFAULT)
SYSTEM - Adds the system specific delimiter (DEFAULT)
SWITCH: NOHDLN - Deactivate writing of a headline by default [FALSE]
NUMBER: LENFLD=L4I/L4X/B4I/B4X/S4I/S4X/HLI/HLX/HBI/HBX/HSI/HSX/L2I/L2X/B2I/B2X/S2I/S2X/S1I/S1X/D1I/D2I/D3I/D4I/D5I/D6I/D7I/D8I/D9I/D0I/D1X/D2X/D3X/D4X/D5X/D6X/D7X/D8X/D9X/D0X - Default format of the length field in front of elements [original]
L4I - Parse binary 4 byte length fields: Little endian integer, length inclusive
L4X - Parse binary 4 byte length fields: Little endian integer, length exclusive (ZIP)
B4I - Parse binary 4 byte length fields: Big endian integer, length inclusive
B4X - Parse binary 4 byte length fields: Big endian integer, length exclusive (USS)
S4I - Parse binary 4 byte length fields: System endian integer, length inclusive
S4X - Parse binary 4 byte length fields: System endian integer, length exclusive (VAR)
HLI - Parse binary 4 byte length fields: Little endian short (LLxx), length inclusive
HLX - Parse binary 4 byte length fields: Little endian short (LLxx), length exclusive
HBI - Parse binary 4 byte length fields: Big endian short (LLxx), length inclusive (MVS)
HBX - Parse binary 4 byte length fields: Big endian short (LLxx), length exclusive
HSI - Parse binary 4 byte length fields: System endian short (LLxx), length inclusive
HSX - Parse binary 4 byte length fields: System endian short (LLxx), length exclusive
L2I - Parse binary 2 byte length fields: Little endian integer, length inclusive
L2X - Parse binary 2 byte length fields: Little endian integer, length exclusive
B2I - Parse binary 2 byte length fields: Big endian integer, length inclusive
B2X - Parse binary 2 byte length fields: Big endian integer, length exclusive
S2I - Parse binary 2 byte length fields: System endian integer, length inclusive
S2X - Parse binary 2 byte length fields: System endian integer, length exclusive (VARCHAR)
S1I - Parse binary 1 byte length fields: Length inclusive
S1X - Parse binary 1 byte length fields: Length exclusive
D1I - Parse decimal 1 byte length fields: Length inclusive
D2I - Parse decimal 2 byte length fields: Length inclusive
D3I - Parse decimal 3 byte length fields: Length inclusive
D4I - Parse decimal 4 byte length fields: Length inclusive
D5I - Parse decimal 5 byte length fields: Length inclusive
D6I - Parse decimal 6 byte length fields: Length inclusive
D7I - Parse decimal 7 byte length fields: Length inclusive
D8I - Parse decimal 8 byte length fields: Length inclusive
D9I - Parse decimal 9 byte length fields: Length inclusive
D0I - Parse decimal 10 byte length fields: Length inclusive
D1X - Parse decimal 1 byte length fields: Length exclusive
D2X - Parse decimal 2 byte length fields: Length exclusive
D3X - Parse decimal 3 byte length fields: Length exclusive
D4X - Parse decimal 4 byte length fields: Length exclusive
D5X - Parse decimal 5 byte length fields: Length exclusive
D6X - Parse decimal 6 byte length fields: Length exclusive
D7X - Parse decimal 7 byte length fields: Length exclusive
D8X - Parse decimal 8 byte length fields: Length exclusive
D9X - Parse decimal 9 byte length fields: Length exclusive
D0X - Parse decimal 10 byte length fields: Length exclusive
STRING: ELMDLM='bin'/CR-ASCII/LF-ASCII/NL-ASCII/CRLF-ASCII/CR-EBCDIC/LF-EBCDIC/NL-EBCDIC/CRLF-EBCDIC/CR-UTF08/LF-UTF08/NL-UTF08/CRLF-UTF08/CR-UTF16BE/LF-UTF16BE/NL-UTF16BE/CRLF-UTF16BE/CR-UTF16LE/LF-UTF16LE/NL-UTF16LE/CRLF-UTF16LE/CR-UTF32BE/LF-UTF32BE/NL-UTF32BE/CRLF-UTF32BE/CR-UTF32LE/LF-UTF32LE/NL-UTF32LE/CRLF-UTF32LE - Default delimiter used to define end of element [original]
CR-ASCII - Delimiter: carriage return in ASCII (0x0D)
LF-ASCII - Delimiter: line feed in ASCII (0x0A)
NL-ASCII - Delimiter: new line in ASCII (0x85)
CRLF-ASCII - Delimiter: carriage return line feed in ASCII (0x0D0A)
CR-EBCDIC - Delimiter: carriage return in EBCDIC (0x0D)
LF-EBCDIC - Delimiter: line feed in EBCDIC (0x25)
NL-EBCDIC - Delimiter: new line in EBCDIC (0x15)
CRLF-EBCDIC - Delimiter: carriage return line feed in EBCDIC (0x0D25)
CR-UTF08 - Delimiter: carriage return in UTF-8 (0x0D)
LF-UTF08 - Delimiter: line feed in UTF-8 (0x0A)
NL-UTF08 - Delimiter: new line in UTF-8 (0xC285)
CRLF-UTF08 - Delimiter: carriage return line feed in UTF-8 (0x0D0A)
CR-UTF16BE - Delimiter: carriage return in UTF-16BE (0x000D)
LF-UTF16BE - Delimiter: line feed in UTF-16BE (0x000A)
NL-UTF16BE - Delimiter: new line in UTF-16BE (0x0085)
CRLF-UTF16BE - Delimiter: carriage return line feed in UTF-16BE (0x000D000A)
CR-UTF16LE - Delimiter: carriage return in UTF-16LE (0x0D00)
LF-UTF16LE - Delimiter: line feed in UTF-16LE (0x0A00)
NL-UTF16LE - Delimiter: new line in UTF-16LE (0x8500)
CRLF-UTF16LE - Delimiter: carriage return line feed in UTF-16LE (0x0D000A00)
CR-UTF32BE - Delimiter: carriage return in UTF-32BE (0x0000000D)
LF-UTF32BE - Delimiter: line feed in UTF-32BE (0x0000000A)
NL-UTF32BE - Delimiter: new line in UTF-32BE (0x00000085)
CRLF-UTF32BE - Delimiter: carriage return line feed in UTF-32BE (0x0000000D0000000A)
CR-UTF32LE - Delimiter: carriage return in UTF-32LE (0x0D000000)
LF-UTF32LE - Delimiter: line feed in UTF-32LE (0x0A000000)
NL-UTF32LE - Delimiter: new line in UTF-32LE (0x85000000)
CRLF-UTF32LE - Delimiter: carriage return line feed in UTF-32LE (0x0D0000000A000000)
NUMBER: FIXLEN=num - Default length for fixed-length fields (activate cut or padding) [original]
NUMBER: PADBYT=num - Default padding byte to pad data to the given fixed length [0x00]
NUMBER: ENCODE/DECODE=OFF/BASE16/BASE32/BASE64 - Default base encoding of binary data [BASE16(text output), NONE(binary output)]
OFF - No en/decoding (copy)
BASE16 - Base16 (hexadecimal) encoding
BASE32 - Base32 encoding
BASE64 - Base64 encoding
NUMBER: INTFMT=BIN/BCD/STR - Default format for integer values [auto]
BIN - Integer in binary format (two's complement)
BCD - Binary coded decimal (BCD) number
STR - String representation of an integer
NUMBER: FLTFMT=BIN/BCD/STR - Default format for floating point values [auto]
BIN - Floating point number in binary format
BCD - Binary coded decimal (BCD) floating point number
STR - String representation of an floating point number
STRING: INTVAL='str' - Default value used, to produce an empty integer string [NONE]
STRING: FLTVAL='str' - Default value (period) used, to produce an empty float string [NONE]
NUMBER: SIGMOD=IFNEGATIVE/SPACEIFPOSITIVE/PLUSIFPOSITIVE - Default handling of leading sign for numbers [IFNEGATIVE]
IFNEGATIVE - Minus for negative values only, no sign if positive
SPACEIFPOSITIVE - Minus for negative, space for positive values
PLUSIFPOSITIVE - Minus for negative, plus for positive values
NUMBER: INTBAS=num/BIN/B02/OCT/B08/DEC/B10/HEX/B16 - Default base / radix for integers [DECIMAL]
BIN - Binary base (2)
B02 - Base 2 (binary)
OCT - Octal base (8)
B08 - Base 8 (octal)
DEC - Decimal base (10)
B10 - Base 10 (decimal)
HEX - Hexadecimal base (16)
B16 - Base 16 (hexadecimal)
NUMBER: INTCAS=UPPER/LOWER - Default upper or lower case for hexadecimal numbers [NONE]
UPPER - Change character to upper case
LOWER - Change character to lower case
NUMBER: FRASEP=SYSTEM/PERIOD/COMMA/APOSTROPHE - Default floating point separator [SYSTEM]
SYSTEM - Use locale dependent separator
PERIOD - Use period (.) as separator
COMMA - Use comma (,) as separator
APOSTROPHE - Use apostrophe (') as separator
SWITCH: FLTSIG - Default: float is signed [FALSE]
SWITCH: INTSIG - Default: integer is signed [FALSE]
NUMBER: ENDIAN=SYSTEM/BIG/LITTLE/LOCAL - Default byte order for binary numbers [SYSTEM]
SYSTEM - Byte order of the default logical system
BIG - Big endian byte order
LITTLE - Little endian byte order
LOCAL - Byte order of the real physical system
NUMBER: INTWID=num/W08/W16/W32/W64 - Default width of integer in bits [dynamic]
W08 - 8 bit integer
W16 - 16 bit integer
W32 - 32 bit integer
W64 - 64 bit integer
NUMBER: FLTWID=num/W32/W64 - Default width of floating point number in bits [64]
W32 - 32 bit integer
W64 - 64 bit integer
NUMBER: FLTTYP=SYSTEM - Default type of floating point format [SYSTEM]
SYSTEM - Floating-point representation of the system's architecture
NUMBER: BCDTYP=UNPACKED/PACKED/ZONED - Default BCD type [UNPACKED]
UNPACKED - Unpacked BCD number
PACKED - Packed BCD number
ZONED - Zoned BCD number
NUMBER: INTDIG=num - Default number of integral digits (before decimal separator)
NUMBER: FRADIG=num - Default number of fractional digits (after decimal separator)
NUMBER: FROUND=AWAYFROMZERO/NEAREST/TOWARDZERO/ERROR - Rounding method if fractional digits don't fit [TOWARDZERO]
AWAYFROMZERO - Round fractional part away from zero (0.1 => 1; -0.1 => -1)
NEAREST - Round fractional part toward nearest integer (0.1=>0; 0.5=>1; -0.5=>-1)
TOWARDZERO - Round fractional part toward zero (=cut off) (0.9 => 0; -0.9 => 0)
ERROR - Return an error instead of rounding a too long number
NUMBER: XMLSCM=STRUCTURED/UNSTRUCTURED - Default scheme for XML writing [STRUCTURED]
STRUCTURED - Structured XML with enclosing tag for each row
UNSTRUCTURED - Unstructured XML with enclosing tag only for the table
STRING: VALUE='str' - Default value, if structured formats require optional detection ['0' for float and integer else '']
SWITCH: USENID - Default to activate usage of null indication at write [FALSE]
SWITCH: USEINTEID - Use empty indication, don't print default value if read integer was an empty string [FALSE]
SWITCH: USEFLTEID - Use empty indication, don't print default value if read float was an empty string [FALSE]
SWITCH: NOESCP - Default to deactivate escaping of syntax elements [FALSE]
SWITCH: NOCHECK/NOCHEK/NOCHK - Default to deactivate different data checks [FALSE]
NUMBER: LINEFD=num - Default amount of line feeds in front of each line [1]
NUMBER: INDSIZE=num - Default indentation size for XML writing [2 if space, 1 if tab]
NUMBER: INDCHAR/INDCHR=SPACE/TABULATOR - Default indentation character used to indent XML tags [SPACE]
SPACE - Use the space character as indentation character
TABULATOR - Use the tabulator character as indentation character
STRING: COMMENT='str' - Default comment for write operations [auto]
NUMBER: ALIGN=num - Default alignment for data fields in flat formats [1 (no alignment)]
SWITCH: SYSTEM - Enforce system character set, endianness, delimiter, etc. if nothing else is defined[FALSE]
SWITCH: TLRCLS - Close one additional level if trailer was written [FALSE]
SWITCH: FLATTX - Don't fall back to root level for each transaction [FALSE]