
• “sorted” (page 53)
• “startseq” (page 53)
• “system” (page 54)
• “tenacity” (page 54)
• “timeout” (page 54)
• “truncate” (page 54)
• “url” (page 54)
• “user” (page 55)
Typeformats
The typeformats section defines various formats in which to represent data types.
typeformats
{
format_definition [, format_definition ]...
}
format-definition:
formatname datatype formatstring
format-definition
One or more occurrences of format-definition, separated by a comma (,). The last
format-definition should not use the comma separator.
formatname
The name you choose for this typeformat. It must be unique among existing typeformats.
formatname is case-insensitive and cannot exceed 64 bytes.
datatype
A supported data type. See “Supported Data Types” (page 45) for a list of supported data
types.
formatstring
Defines the pattern for this field. For a load operation, formatstring tells Transporter how
to interpret source file values. For an extract operation, formatstring tells Transporter
how to write target file values.
• Character data types
Specify “default”. It is the only format supported.
• Integral data types
— decimal — values are interpreted as decimal values with an optional leading sign
character
— octal — values are interpreted as octal values with an optional leading sign character.
For numeric and decimal data types, a period can be used to separate the integral
portion of the value from the fractional portion. For example, the value 10.5 can be
represented in octal as “12.4”.
— hex — values are interpreted as hexadecimal values with an optional leading sign
character.
For numeric and decimal data types, a period can be used to separate the integral
portion of the value from the fractional portion. For example, the value -10.5 can be
represented in hexadecimal as “-A.8”.
Control File Organization and Syntax 29
Commentaires sur ces manuels