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