The methods defined in the ExternalDatabase class are summarized in the following table.
| Method | Description |
|---|---|
| abortExternalTransaction | Rolls back the changes made during the current transaction |
| beginExternalTransaction | Starts a database transaction |
| canTransact | Returns true if the external database supports transactions |
| close | Closes the connection to an external database |
| commitExternalTransaction | Commits a transaction |
| executeSQL | Directly executes an SQL statement |
| getFileDSN | Returns the file data source name |
| getLastError | Returns the last ODBC exception when the isSQLValid method returns false |
| getMachineDSN | Returns the machine data source name |
| importStoredProcedures | For internal use only |
| isOpen | Returns true if the external database is currently open |
| isSQLValid | Checks the syntax of an SQL statement |
| isUpdatable | Returns true if the external database can be updated |
| loadProcedure | Reserved for future use |
| open | Opens a connection to an external database |
| setFileDSN | Programmatically sets the file data source name |
| setMachineDSN | Programmatically sets the machine data source name |