Field level

Field level has the following properties.

This has the following properties:

  • Bytes to Skip. Skip the specified number of bytes from the end of the previous column to the beginning of this column.
  • Delimiter. Specifies the trailing delimiter of the column. Type an ASCII character or select one of whitespace, end, none, null, comma, or tab.
    • whitespace. The last column of each record will not include any trailing white spaces found at the end of the record.
    • end. The end of a field is taken as the delimiter, that is, there is no separate delimiter. This is not the same as a setting of `None' which is used for fields with fixed-width columns.
    • none. No delimiter (used for fixed-width).
    • null. ASCII Null character is used.
    • comma. ASCII comma character used.
    • tab. ASCII tab character used.
  • Delimiter string. Specify a string to be written at the end of the column. Enter one or more characters. This is mutually exclusive with Delimiter, which is the default. For example, specifying `, ` (comma space - you do not need to enter the inverted commas) would have the column delimited by `, `.
  • Drop on input. Select this property when you must fully define the meta data for a data set, but do not want the column actually read into the data set.
  • Prefix bytes. Specifies that this column is prefixed by 1, 2, or 4 bytes containing, as a binary value, either the column's length or the tag value for a tagged column. You can use this option with variable-length fields. Variable-length fields can be either delimited by a character or preceded by a 1-, 2-, or 4-byte prefix containing the field length. InfoSphere® DataStage® inserts the prefix before each field.

    This property is mutually exclusive with the Delimiter, Quote, and Final Delimiter properties, which are used by default.

  • Print field. This property is intended for use when debugging jobs. Set it to have InfoSphere DataStage produce a message for each of the columns it reads. The message has the format: 
    
Importing N: D

    where:

    • N is the column name.
    • D is the imported data of the column. Non-printable characters contained in D are prefixed with an escape character and written as C string literals; if the column contains binary data, it is output in octal format.
  • Quote. Specifies that variable length columns are enclosed in single quotes, double quotes, or another ASCII character or pair of ASCII characters. Choose Single or Double, or enter a character.
  • Start position. Specifies the starting position of a column in the record. The starting position can be either an absolute byte offset from the first record position (0) or the starting position of another column.
  • Tag case value. Explicitly specifies the tag value corresponding to a subfield in a tagged subrecord. By default the fields are numbered 0 to N-1, where N is the number of fields. (A tagged subrecord is a column whose type can vary. The subfields of the tagged subrecord are the possible types. The tag case value of the tagged subrecord selects which of those types is used to interpret the column's value for the record.)