iAnywhere.com - input_format option [Interactive SQL]

Sets the default data format expected by the INPUT statement.

String (see below for allowed values)

ASCII

Allowable input formats are:

ASCII Input lines are assumed to be ASCII 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.
DBASE The file is in dBASE II or dBASE III format. Interactive SQL attempts to determine which format, based on information in the file.
DBASEII The file is in dBASE II format.
DBASEIII The file is in dBASE III format.
EXCEL Input file is in the format of Microsoft Excel 2.1.
FIXED Input lines are in fixed format.
FOXPRO The file is in FoxPro format.
LOTUS The file is a Lotus WKS format worksheet. INPUT assumes that the first row in the Lotus WKS format worksheet consists of column names.