Group Listing of Commands
Connection and Configuration Commands
database connect | Connect to an ODBC database. |
database configure | Configure ODBC datasources. |
database datasources | Return a list of ODBC datasources. |
database drivers | Return a list of ODBC drivers. |
Data Manipulation Commands
In the following commands,
database-id
is the database identifier for
a database connection created using the database
connect command:
| Execute an SQL statement. |
| Disconnect from the database. |
| Set connection-specific attributes. |
| Get connection-specific attributes. |
| Commit current transaction. |
| Cancel current transaction. |
| Return a list of database tables. |
| Return a list of database columns. |
| Return a list of database indexes. |
| Create a statement object. |
Statement Commands
In the following commands,
statement-id
is a statement identifier
created using the database-id
statement command:
statement-id
runExecute the statement and return results.
statement-id
execute [args
]Execute the statement without returning results.
statement-id
fetch [arrayName
] [columnNames
]With no parameters, read one row, returning the results or an empty string when there are no more results to be read. With an array name, read the results into an array. Column names can optionally be specified.
statement-id
columnsReturn a list of statement column attributes.
statement-id ...
Get Tcl/Tk in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.