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,NOCASE,HEADLN,CASEHL,SEPCHR[num/COMMA/COLON/SEMICOLON/TABULATOR/BLANK...],FLDCHR[num/QUOTATION/APOSTROPHE/GRAVEACCENT/PARENTHESES/RBRACKETS/SBRACKETS/BRACES/CBRACKETS/ABRACKETS...],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,ANDEOD,INTFMT=BIN/BCD/STR,FLTFMT=BIN/BCD/STR,INTVAL='str',FLTVAL='str',DECODE/ENCODE=OFF/BASE16/BASE32/BASE64,IGNSPC,CASMOD=UPPER/LOWER/FOLD/SUPPER/SLOWER/USRTAB,USRTAB='str'/NPAS/SEPA/DELA/DLAX,ONEMAP,CMBFRM=NFD/NFC/AUTO/ON/OFF,WITSPC=PRESERVE/REPLACE/COLLAPSE/REMOVE/TRAILING/LEADING/BOTH/NUMBER,INTBAS=num/BIN/B02/OCT/B08/DEC/B10/HEX/B16,FLTTYP=SYSTEM,FLTSIG,INTSIG,BCDTYP=UNPACKED/PACKED/ZONED,FRADIG=num,FRASEP=SYSTEM/PERIOD/COMMA/APOSTROPHE,ENDIAN=SYSTEM/BIG/LITTLE/LOCAL,XMLSCM=STRUCTURED/UNSTRUCTURED,XMLNOC,XMLPFX[=IGNOREALL/IGNEXCXML/IGNXMLNS],XMLWRN[=MANDATORY/BRANCH/ATTRIBUTE/DATAFIELD/MISSING/NSPREFIX/ALL],XMLERR[=BRANCH/ATTRIBUTE/DATAFIELD/MISSING/ALL],XMLNS[()...],VALUE='str',PADBYT=num,ALIGN=num,ALWTRC)
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.
NUMBER: TYPE=BINARY/STRING/INTEGER/FLOAT - Default data type used for conversion [NONE]
BINARY - Read binary data
STRING - Read a string data type
INTEGER - Read a integer value
FLOAT - Read a fractional numbers
SWITCH: NOCASE - No case-sensitive comparison of tags and delimiter [FALSE]
SWITCH: HEADLN - Read over head line without compare of column names [FALSE]
SWITCH: CASEHL - Activate case sensitive comparison of headline identifier [FALSE]
NUMBER: SEPCHR[num/COMMA/COLON/SEMICOLON/TABULATOR/BLANK...] - Default list of separator characters as Unicode codepoints for CSV files [COMMA,SEMICOLON]
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 list of field enclosing characters as Unicode codepoints for CSV files [QUOTATION,APOSTROPHE,GRAVE]
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: 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 [S2X (VARCHAR)]
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 - Delimiter written after a data 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)
SWITCH: ANDEOD - Don't accept a delimiter at the end of a row [OFF]
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: DECODE/ENCODE=OFF/BASE16/BASE32/BASE64 - Default base decoding for binary data [BASE16(text input), NONE(binary input)]
OFF - No en/decoding (copy)
BASE16 - Base16 (hexadecimal) encoding
BASE32 - Base32 encoding
BASE64 - Base64 encoding
SWITCH: IGNSPC - Ignore whitespace characters during base decoding [FALSE]
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: FLTTYP=SYSTEM - Default type of floating point format [SYSTEM]
SYSTEM - Floating-point representation of the system's architecture
SWITCH: FLTSIG - Default: floating point numbers are signed [FALSE]
SWITCH: INTSIG - Default: integers are signed [FALSE]
NUMBER: BCDTYP=UNPACKED/PACKED/ZONED - Default BCD type [UNPACKED]
UNPACKED - Unpacked BCD number
PACKED - Packed BCD number
ZONED - Zoned BCD number
NUMBER: FRADIG=num - Default number of fractional digits (after comma)
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
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: XMLSCM=STRUCTURED/UNSTRUCTURED - Default scheme for XML parsing [STRUCTURED]
STRUCTURED - Structured XML with enclosing tag for each row
UNSTRUCTURED - Unstructured XML with enclosing tag only for the table
SWITCH: XMLNOC - Default if no check of optional branches for mandatory fields (increase performance) [FALSE]
NUMBER: XMLPFX=IGNOREALL/IGNEXCXML/IGNXMLNS - Ignore prefix (pfx:tag) at tag compare [NONE]
IGNOREALL - Ignore each prefix
IGNEXCXML - Ignore each prefix except starting with 'xml'
IGNXMLNS - Ignore each prefix except starting with 'xmlns' and prevent missing warning/error for it
NUMBER: XMLWRN=MANDATORY/BRANCH/ATTRIBUTE/DATAFIELD/MISSING/NSPREFIX/ALL - Default to activate different warnings at XML parsing [NONE]
MANDATORY - No error but warning if mandatory element not found
BRANCH - Warning if a branch without column description in the XML document
ATTRIBUTE - Warning if a attribute without column description in the XML document
DATAFIELD - Warning if a data field without column description in the XML document
MISSING - Warning if a branch, attribute or data field without column description in the XML document
NSPREFIX - Warning if a tag name without matching namespace prefix in row definition
ALL - Activate all additional warnings
NUMBER: XMLERR=BRANCH/ATTRIBUTE/DATAFIELD/MISSING/ALL - Default to activate different errors at XML parsing [NONE]
BRANCH - Error if a branch without column description in the XML document
ATTRIBUTE - Error if a attribute without column description in the XML document
DATAFIELD - Error if a data field without column description in the XML document
MISSING - Error if a branch, attribute or data field without column description in the XML document
ALL - Activate all additional errors
STRING: VALUE='str' - Default value, if element not in structure formats ['0' for float and integer else '']
NUMBER: PADBYT=num - Default to remove this padding byte (mainly for fixed length formats)
NUMBER: ALIGN=num - Default alignment for data fields in flat formats [1 (no alignment)]
SWITCH: ALWTRC - Allow truncation of values [FALSE]