%SYSTEM.SQLGateway
abstract class %SYSTEM.SQLGateway extends %SYSTEM.Help
The %SYSTEM.SQLGateway class provides an interface for managing Gateway connections.You can use it via the special $system object:
Do $system.SQLGateway.DropAll()
Method Inventory
- DropAll()
- DropConnection()
- GetJDBCConnection()
- GetODBCConnection()
- SetAllODBCConnectOption()
- SetAutoCommit()
- TestConnection()
- Transact()
Methods
nm - connection name
It returns an empty string if the connection attempt was unsuccessful.
nm - connection name
It returns an empty string if the connection attempt was unsuccessful.
nm - connection name
timeout - timeout
legacy - legacy mode
option - option to set
vparm - value associated with option
ac = { 0 - AUTOCOMMIT OFF, 1 - AUTOCOMMIT ON}
It writes the diagnostic ouput to a current device.
nm - connection name
timeout - timeout (only relevant for ODBC connections)
verbose - setting to a non 0 value will cause the diagnostic output to the current device
error - output variable for passing back an error if it occurs
type = { 0 - SQL_COMMIT, 1 - SQL_ROLLBACK}