C_format. Perform non-default conversion of data
from a string to floating-point data. This property specifies a C-language
format string used for reading floating point strings. This is passed to sscanf().
Character Set. Choose from ASCII or EBCDIC.
Default. The default value for a column. This is
used for data written by a Generate stage. It also supplies the value to substitute
for a column that causes an error (whether written or read).
Data Format. Specifies the data representation format
of a column. Choose from:
binary
text
Field max width. The maximum number of bytes in a
column represented as a string. Enter a number. Enter a number. This is useful
where you are storing numbers as text. If you are using a fixed-width character
set, you can calculate the length exactly. If you are using variable-length
character set, calculate an adequate maximum width for your fields. Applies
to fields of all data types except date, time, timestamp, and raw; and record,
subrec, or tagged if they contain at least one field of this type.
Field width. The number of bytes in a column represented
as a string. Enter a number. This is useful where you are storing numbers
as text. If you are using a fixed-width charset, you can calculate the number
of bytes exactly. If it's a variable length encoding, base your calculation
on the width and frequency of your variable-width characters. Applies to fields
of all data types except date, time, timestamp, and raw; and record, subrec,
or tagged if they contain at least one field of this type.
In_format. Format string used for conversion of data
from string to floating point. This is passed to sscanf(). By default, InfoSphere® DataStage® invokes
the C sscanf() function to convert a numeric field formatted as a string
to floating point data. If this function does not output data in a satisfactory
format, you can specify the in_format property to pass formatting arguments
to sscanf().
Is link field. Selected to indicate that a column
holds the length of a another, variable-length column of the record or of
the tag value of a tagged record field.
Out_format. Format string used for conversion of
data from floating point to a string. This is passed to sprintf().
By default, InfoSphere DataStage invokes
the C sprintf() function to convert a numeric field formatted as floating
point data to a string. If this function does not output data in a satisfactory
format, you can specify the out_format property to pass formatting arguments
to sprintf().
Pad char. Specifies the pad character used when the
floating point number is written to an external string representation. Enter
a character (single-bye for strings, can be multi-byte for ustrings) or choose
null or space. The pad character is used when the external string representation
is larger than required to hold the written field. In this case, the external
string is filled with the pad character to its full length. Space is the default.
IBM InfoSphere DataStage and InfoSphere QualityStage, Version 8.5
This topic is also in the IBM InfoSphere DataStage and QualityStage Parallel Job Developer's Guide.
