Direct commands cause the program to execute some database server service, such as logging into a SQL Server or connecting to a Database Manager database. These commands do not contain SQL statements.
Command |
Description |
(DB/2 Only) Disconnects from the currently running database; runs DB/2 dynamic bind routine; and connects to the new database. Retained for compatibility with SQL Server, Sybase, ODBC and ORACLE where it simulates the bind by starting the specified database catalog. |
|
Commits a series of changes to the database tables. Unless your application is using the auto commit mode, you must commit changes before disconnecting or swapping databases otherwise the changes will be discarded. |
|
Logs the user into a database server or data source. Not applicable to DB/2 |
|
Discard changes must to the database, since the last commit. Ignored if commit mode is auto. |
|
DB/2: Connects to a database. SQL Server: Connects to a particular database on the current SQL Server. This is the same as the TRANSACT-SQL use command. ORACLE & ODBC: Closes the current database and switches to another. |
|
(DB/2 & ODBC Only) Disconnects from the currently running database. |
