DEFAULTS

Synopsis

HELP:   Default values to simplify row specifications or automatic write
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,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/INT/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)

Description

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.

Arguments

• NUMBER: TYPE=BINARY/STRING/INTEGER/INT64/FLOAT - Default data type used for conversion [NONE]
  • BINARY - Write binary data
  • STRING - Write a string data type
  • INTEGER - Write a variable size integer value
  • INT64 - Write a 64 bit integer value
  • FLOAT - Write a fractional number
• 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/INT/STR - Default format for floating point values [auto]
  • BIN - Floating point number in binary format
  • BCD - Binary coded decimal (BCD) floating point number
  • INT - Integer multiplied by 10 to the power of fractional digits
  • 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 writing [2 if space, 1 if tab] - explicit 0 to minimize (no indentation)
• NUMBER: INDCHAR/INDCHR=SPACE/TABULATOR - Default indentation character used to indent 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]