HELP: Default values to simplify column specifications 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 columns which are defined within the same row 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 dataSTRING - Write a string data typeINTEGER - Write a integer valueFLOAT - Write a fractional numbersNUMBER: 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 characterAPOSTROPHE - Apostrophe as enclosing characterGRAVEACCENT - Grave accent as enclosing characterPARENTHESES - Round brackets as enclosing characterRBRACKETS - Round brackets as enclosing characterSBRACKETS - Square brackets as enclosing characterBRACES - Curly brackets as enclosing characterCBRACKETS - Curly brackets as enclosing characterABRACKETS - Angle brackets as enclosing characterNUMBER: FLDMTD=ALWAYS/IFREQ/NONE - Default method for field enclosing character [ALWAYS]
ALWAYS - Use always field enclosing charactersIFREQ - Use field enclosing characters only if requiredNONE - Don't use field enclosing charactersNUMBER: 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 inclusiveL4X - Parse binary 4 byte length fields: Little endian integer, length exclusive (ZIP)B4I - Parse binary 4 byte length fields: Big endian integer, length inclusiveB4X - Parse binary 4 byte length fields: Big endian integer, length exclusive (USS)S4I - Parse binary 4 byte length fields: System endian integer, length inclusiveS4X - Parse binary 4 byte length fields: System endian integer, length exclusive (VAR)HLI - Parse binary 4 byte length fields: Little endian short (LLxx), length inclusiveHLX - Parse binary 4 byte length fields: Little endian short (LLxx), length exclusiveHBI - 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 exclusiveHSI - Parse binary 4 byte length fields: System endian short (LLxx), length inclusiveHSX - Parse binary 4 byte length fields: System endian short (LLxx), length exclusiveL2I - Parse binary 2 byte length fields: Little endian integer, length inclusiveL2X - Parse binary 2 byte length fields: Little endian integer, length exclusiveB2I - Parse binary 2 byte length fields: Big endian integer, length inclusiveB2X - Parse binary 2 byte length fields: Big endian integer, length exclusiveS2I - Parse binary 2 byte length fields: System endian integer, length inclusiveS2X - Parse binary 2 byte length fields: System endian integer, length exclusive (VARCHAR)S1I - Parse binary 1 byte length fields: Length inclusiveS1X - Parse binary 1 byte length fields: Length exclusiveD1I - Parse decimal 1 byte length fields: Length inclusiveD2I - Parse decimal 2 byte length fields: Length inclusiveD3I - Parse decimal 3 byte length fields: Length inclusiveD4I - Parse decimal 4 byte length fields: Length inclusiveD5I - Parse decimal 5 byte length fields: Length inclusiveD6I - Parse decimal 6 byte length fields: Length inclusiveD7I - Parse decimal 7 byte length fields: Length inclusiveD8I - Parse decimal 8 byte length fields: Length inclusiveD9I - Parse decimal 9 byte length fields: Length inclusiveD0I - Parse decimal 10 byte length fields: Length inclusiveD1X - Parse decimal 1 byte length fields: Length exclusiveD2X - Parse decimal 2 byte length fields: Length exclusiveD3X - Parse decimal 3 byte length fields: Length exclusiveD4X - Parse decimal 4 byte length fields: Length exclusiveD5X - Parse decimal 5 byte length fields: Length exclusiveD6X - Parse decimal 6 byte length fields: Length exclusiveD7X - Parse decimal 7 byte length fields: Length exclusiveD8X - Parse decimal 8 byte length fields: Length exclusiveD9X - Parse decimal 9 byte length fields: Length exclusiveD0X - Parse decimal 10 byte length fields: Length exclusiveSTRING: 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) encodingBASE32 - Base32 encodingBASE64 - Base64 encodingNUMBER: INTFMT=BIN/BCD/STR - Default format for integer values [auto]
BIN - Integer in binary format (two's complement)BCD - Binary coded decimal (BCD) numberSTR - String representation of an integerNUMBER: FLTFMT=BIN/BCD/STR - Default format for floating point values [auto]
BIN - Floating point number in binary formatBCD - Binary coded decimal (BCD) floating point numberSTR - String representation of an floating point numberSTRING: 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 positiveSPACEIFPOSITIVE - Minus for negative, space for positive valuesPLUSIFPOSITIVE - Minus for negative, plus for positive valuesNUMBER: 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 caseLOWER - Change character to lower caseNUMBER: FRASEP=SYSTEM/PERIOD/COMMA/APOSTROPHE - Default floating point separator [SYSTEM]
SYSTEM - Use locale dependent separatorPERIOD - Use period (.) as separatorCOMMA - Use comma (,) as separatorAPOSTROPHE - Use apostrophe (') as separatorSWITCH: 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 systemBIG - Big endian byte orderLITTLE - Little endian byte orderLOCAL - Byte order of the real physical systemNUMBER: INTWID=num/W08/W16/W32/W64 - Default width of integer in bits [dynamic]
W08 - 8 bit integerW16 - 16 bit integerW32 - 32 bit integerW64 - 64 bit integerNUMBER: FLTWID=num/W32/W64 - Default width of floating point number in bits [64]
W32 - 32 bit integerW64 - 64 bit integerNUMBER: FLTTYP=SYSTEM - Default type of floating point format [SYSTEM]
SYSTEM - Floating-point representation of the system's architectureNUMBER: BCDTYP=UNPACKED/PACKED/ZONED - Default BCD type [UNPACKED]
UNPACKED - Unpacked BCD numberPACKED - Packed BCD numberZONED - Zoned BCD numberNUMBER: 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 numberNUMBER: XMLSCM=STRUCTURED/UNSTRUCTURED - Default scheme for XML writing [STRUCTURED]
STRUCTURED - Structured XML with enclosing tag for each rowUNSTRUCTURED - Unstructured XML with enclosing tag only for the tableSTRING: 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 characterTABULATOR - Use the tabulator character as indentation characterSTRING: 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]