The following explains the float type properties:
- 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 the following data format:
- Field max
width. The maximum 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 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.