HELP: Default values to simplify row specifications TYPE: OBJECT SYNTAX: DEFAULTS(TYPE=BINARY/STRING/INTEGER/INT64/FLOAT,VARFMT=PLENPTR/ALENPTR/PPTRLEN/APTRLEN/PFLGLENPTR/PPTRLENFLG/PCLNDLNCOLDAT/PFLGCLNDLNCOLDAT/AFLGCLNDLNCOLDAT,ARYFMT=PCLNDLNCOLDAT,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/INT/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 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.
NUMBER: TYPE=BINARY/STRING/INTEGER/INT64/FLOAT - Default data type used for conversion [NONE]
BINARY - Read binary dataSTRING - Read a string data typeINTEGER - Read a variable size integer valueINT64 - Read a 64 bit integer valueFLOAT - Read a fractional numberSWITCH: NOCASE - No case-sensitive comparison of tags, values 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 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: 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 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 - 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) numberSTR - String representation of an integerNUMBER: FLTFMT=BIN/BCD/INT/STR - Default format for floating point values [auto]
BIN - Floating point number in binary formatBCD - Binary coded decimal (BCD) floating point numberINT - Integer multiplied by 10 to the power of fractional digitsSTR - 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: 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) encodingBASE32 - Base32 encodingBASE64 - Base64 encodingSWITCH: 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 architectureSWITCH: 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 numberPACKED - Packed BCD numberZONED - Zoned BCD numberNUMBER: FRADIG=num - Default number of fractional digits (after comma)NUMBER: 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 separatorNUMBER: 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: XMLSCM=STRUCTURED/UNSTRUCTURED - Default scheme for XML parsing [STRUCTURED]
STRUCTURED - Structured XML with enclosing tag for each rowUNSTRUCTURED - Unstructured XML with enclosing tag only for the tableSWITCH: 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 prefixIGNEXCXML - Ignore each prefix except starting with 'xml'IGNXMLNS - Ignore each prefix except starting with 'xmlns' and prevent missing warning/error for itNUMBER: 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 foundBRANCH - Warning if a branch without column description in the XML documentATTRIBUTE - Warning if a attribute without column description in the XML documentDATAFIELD - Warning if a data field without column description in the XML documentMISSING - Warning if a branch, attribute or data field without column description in the XML documentNSPREFIX - Warning if a tag name without matching namespace prefix in row definitionALL - Activate all additional warningsNUMBER: 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 documentATTRIBUTE - Error if a attribute without column description in the XML documentDATAFIELD - Error if a data field without column description in the XML documentMISSING - Error if a branch, attribute or data field without column description in the XML documentALL - Activate all additional errorsSTRING: 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]