output

Imports data into a database table from an external file or from the keyboard.

Syntax

output to filename
	[ append ]
	[ verbose ]
	[ format {ascii | dbase | dbasell| dbaselll 
		| excel | fixed | foxpro | lotus | sql | xml}]
	[ escape character character ]
	[ escapes { on | off}
	[ delimited by string ]
	[ quote string [ all ] ]
	[ column widths (integer , . . . ) ]
	[ hexidecimal { on | off | asis } ]
	[ encoding {string | identifier}]

Parameters

Examples

Usage

  • The output statement copies the information retrieved by the current query to a file.

  • You can specify the output format with the optional format clause. If you do not specify the format clause, the Interactive SQL output_format option setting is used.

  • The current query is the select or input statement that generated the information appearing on the Results tab in the Results pane. The output statement reports an error if there is no current query.

  • In Interactive SQL, the Results tab displays only the results of the current query. All previous query results are replaced with the current query results.

Permissions

Any user can execute this command.