Float type

Float type has several 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:
    • 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.