Execute SQL
- Author: O.Conrad (c) 2010
- Menu: Database | ODBC | Tools
Description
Execute SQL commands on a connected ODBC source. Separate different commands with a semicolon (';').
Parameters
Name | Type | Identifier | Description | Constraints | |
---|---|---|---|---|---|
Options | Data Source | text | ODBC_DSN | - | - |
User | text | ODBC_USR | - | - | |
Password | text | ODBC_PWD | - | - | |
SQL Statement | long text | SQL | - | Default: CREATE TABLE myTable1 (Col1 VARCHAR(255) PRIMARY KEY, Col2 INTEGER); INSERT INTO myTable1 (Col1, Col2) VALUES('First Value', 1); DROP TABLE myTable1; | |
Commit | boolean | COMMIT | - | Default: 1 | |
Stop on Error | boolean | STOP | - | Default: 0 |
Command Line
Usage: saga_cmd db_odbc 3 [-ODBC_DSN] [-ODBC_USR ] [-ODBC_PWD ] [-SQL ] [-COMMIT ] [-STOP ] -ODBC_DSN: Data Source text -ODBC_USR: User text -ODBC_PWD: Password text -SQL: SQL Statement long text Default: CREATE TABLE myTable1 (Col1 VARCHAR(255) PRIMARY KEY, Col2 INTEGER); INSERT INTO myTable1 (Col1, Col2) VALUES('First Value', 1); DROP TABLE myTable1; -COMMIT: Commit boolean Default: 1 -STOP: Stop on Error boolean Default: 0