SQL Anywhere® Server - Database Administration  > SQL Anywhere Administration Tools  > Interactive SQL  > Interactive SQL options

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.

• INPUT statement [Interactive SQL]
• SET OPTION statement [Interactive SQL]