Information icon IBM Information Server, Version 8.1
Feedback

Properties: reference listing

The following table lists all record and field properties in alphabetical order.

Property Specifies See
actual_length Bytes to skip in imported record if the field contains a null; bytes to fill with null-field or specified pad character, if exported field contains a null. actual_length
ascii Character set of data is in ASCII format. ascii
big_endian Multi-byte data types are formatted as big endian. big_endian
binary Field value represented in binary format; decimal represented in packed decimal format; julian day format; time represented as number of seconds from midnight; timestamp formatted as two 32-bit integers binary
c_format Format of text-numeric translation format to and from numeric fields c_format
charset Specifies a character set charset
"record {text} ( " " a:int32; " " b:int16 {binary}; " " c:int8; ) "

check_intact

Error checking of imported records with partial record schema (a suboption of intact) check_intact
date_format Defines a text-string date format or uformat format other than the default; uformat can contain multi-byte Unicode characters date_format
days_since The imported or exported field stores the date as a signed integer containing the number of days since date_in_ISO_format or uformat. days_since
decimal_separator Specifies an ASCII character to separate the integer and fraction components of a decimal decimal_separator
default Default value for a field that causes an error default
default_date_format Provides support for international date components in date fields default_date_format
default_time_format Provides support for international time components in time fields default_time_format
delim Trailing delimiter of all fields delim
delim_string One or more ASCII characters forming trailing delimiter of all fields delim_string
drop Field dropped on import drop
ebcdic Character set of data is in EBCDIC format ebcdic
export_ebcdic_as_ascii Exported field converted from EBCDIC to ASCII export_ebcdic_as_ascii
fill Byte value to fill in gaps in exported record fill
final_delim Delimiter character trailing last field of record final_delim
final_delim_string Delimiter string trailing last field of record final_delim_string
fix_zero A packed decimal field containing all zeros (normally illegal) is treated as a valid representation of zero fix_zero
generate Creation of exported field generate
import_ascii_as_ebcdic Translation of imported string field from ASCII to EBCDIC import_ascii_as_ebcdic
in_format Format of text translation to numeric field in_format
intact The record definition defines a partial record schema intact
julian The imported or exported field represents the date as a numeric value containing Julian day julian
link A field holds the length of a another, variable-length field of the record; field might be a vector link
little_endian Multi-byte data types are formatted as little endian little_endian
max_width Maximum width of the destination field. max_width
midnight_seconds The field represents the time as a binary 32-bit integer containing the number of seconds elapsed from the previous midnight midnight_seconds
native_endian Multi-byte data types are formatted as defined by the native format of the machine; this is the default for import/export operations native_endian
nofix_zero A packed decimal field containing all zeros generates an error (default) nofix_zero
null_field Value of null field in file to be imported; value to write to exported file if source field is null null_field
null_length Imported length meaning a null value; exported field contains a null null_length
overpunch The field has a leading or ending byte that contains a character which specifies both the numeric value of that byte and whether the number as a whole is negatively or positively signed overpunch
out_format Format of numeric translation to text field out_format
packed The imported or exported field contains a packed decimal packed
padchar Pad character of exported strings or numeric values padchar
position The byte offset of the field in the record position
precision The precision of the packed decimal precision
prefix Prefix of all fields of record; also length of prefix holding the length in bytes of a vector prefix
"record {prefix = 2} (" " a:string; " " b:string {prefix = 1}; )"

print_field

Each imported field generates message print_field
quote Field is enclosed in quotes or another ASCII character; useful for variable-length fields quote
record_delim Record delimited by a single ASCII character record_delim
record_delim_string Record delimited by one or more ASCII characters record_delim_string
record_format Variable-length blocked records or implicit records record_format
record_length Fixed length records record_length
record_prefix Records with a length prefix stored as binary data record_prefix
reference Name of field containing field length reference
round Rounding mode of source decimal round
scale The scale of the decimal scale
separate The imported or exported field contains an unpacked decimal with a separate sign byte separate
skip Number of bytes skipped from the end of the previous field to the beginning of this one skip
tagcase Defines the active field in a tagged subrecord tagcase
text Field represented as text-based data; decimal represented in string format; date, time, and timestamp representation is text-based text
time_format The format of an imported or exported field representing a time as a string time_format
timestamp_format The format of an imported or exported field representing a timestamp as a string timestamp_format
vector_prefix Prefix length for element count vector_prefix
width The exact width of the destination field width
zoned The imported or exported field contains an unpacked decimal represented by either ASCII or EBCDIC text zoned

The remainder of this topic consists of an alphabetic listing of all properties. In presenting the syntax, field_definition is the name and data type of the field whose properties are defined.


PDF This topic is also in the IBM WebSphere DataStage and QualityStage Parallel Job Advanced Developer Guide.

Update icon Last updated: 2008-09-30