Module Commit/Rollback Transaction
Execute a commit or rollback on open transactions with ODBC source.
- Author: O.Conrad (c) 2008
- Specification: grid
- Menu: Database|ODBC|Tools
Parameters
| Name | Type | Identifier | Description | Constraints |
Options | DSN | Text | ODBC_DSN | Data Source Name | - |
User | Text | ODBC_USR | User Name | - |
Password | Text | ODBC_PWD | Password | - |
Server Connection | Choice | CONNECTION | Server Connection | Available Choices: [0] Default: 0 |
Server | Choice | SERVERS | - | Available Choices: [0] Default: 0 |
Transactions | Choice | TRANSACT | - | Available Choices: [0] rollback [1] commit Default: 1 |
Command-line
Usage: saga_cmd db_odbc 2 [-ODBC_DSN <str>] [-ODBC_USR <str>] [-ODBC_PWD <str>] [-SERVERS <str>] [-TRANSACT <str>]
-ODBC_DSN:<str> DSN
Text
-ODBC_USR:<str> User
Text
-ODBC_PWD:<str> Password
Text
-SERVERS:<str> Server
Choice
Available Choices:
[0] <not set>
Default: 0
-TRANSACT:<str> Transactions
Choice
Available Choices:
[0] rollback
[1] commit
Default: 1