input_format option [Interactive SQL]

Sets the default data format expected by the INPUT statement.

Allowed values

String (see below for allowed values)

Default

TEXT

Remarks

Allowable input formats are:

  • TEXT   Input lines are assumed to be text characters, one row per line, with values separated by commas. Alphabetic strings can be enclosed in apostrophes (single quotes) or quotation marks (double quotes). Strings containing commas must be enclosed in either single or double quotes. If single or double quotes are used, double the quote character to use it within the string. Optionally, you can use the DELIMITED BY clause to specify a different delimiter string than the default, which is a comma (,).

    Three other special sequences are also recognized. The two characters \n represent a newline character, \\ represents a single backslash character, and the sequence \xDD, where DD is the hexadecimal representation of a character, represents the character with hexadecimal code DD.

  • FIXED   Input lines are in fixed length format.

See also