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. |
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
setSet statement-specific attributes.
statement-id
getGet statement-specific attributes.
statement-id
dropDestroy the statement command.