Interactive dbsql commands

These are the syntax and very brief descriptions for interactive dbsql commands for Adaptive Server. See Reference Manual: Commands for more information.

Clears the Interactive SQL panes.

clear

Opens the Interactive SQL Options dialog.

configure

Establishes a connection to a database.

connect
	[to engine_name]
	[database database_name]
	[as connection_name]
	[user] user_id identified by password
	engine_name, database_name, connection_name, user_id,
		password : {identifier | string | hostvar}

connect using connect_string : {identifier | string | hostvar}

Drops the current connection to a database.

disconnect [{identifier | string | hostvar} | current | all]

Leaves Interactive SQL.

{exit | quit | bye} [{number | connection_variable}]

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

input into [ owner.]table_name
	[ from filename | prompt]
	[ format { ascii | dbase | dbasell | dbaselll | excel | fixed | foxpro | lotus }]
	[ escape character character]
	[ escapes { on | off }
	[ by order | by name ]
	[ delimited by string ]
	[ column widths (integer , . . . ) ]
	[ nostrip ]
	[ ( column_name, . . . ) ]
	[ encoding {identifier | string}]

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

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}]

Specifies parameters to an Interactive SQL command file.

parameters parameter1, parameter2, . . .

Reads Interactive SQL statements from a file.

read [ encoding {identifier | string}] file_name [ parameters ]

Changes the current database connection to another server.

set connection {identifier | string | hostvar}

Changes the values of Interactive SQL options.

set [ temporary] option
	[{identifier | string | hostvar}. | public.]
	{identifier | string | hostvar| builtin_date_strings} = [option_value]

set permanent

set

Starts logging executed SQL statements to a log file.

start logging file_name

Stops logging of executed SQL statements in the current session.

stop logging

Launches an executable file from within Interactive SQL.

system ‘[path] file_name’