Tool Execute SQL

Execute SQL commands on a connected ODBC source. Separate different commands with a semicolon (';').

Author: O.Conrad (c) 2010
Menu: Database|ODBC|Tools

Parameters

	Name	Type	Identifier	Description	Constraints
Options	DSN	text, CMD	`ODBC_DSN`	Data Source Name	-
	User	text, CMD	`ODBC_USR`	User Name	-
	Password	text, CMD	`ODBC_PWD`	Password	-
	Server Connection	choice, GUI	`CONNECTION`	Server Connection	Available Choices: Default: 0
	SQL Statment	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 <str>] [-ODBC_USR <str>] [-ODBC_PWD <str>] [-SQL <str>] [-COMMIT <str>] [-STOP <str>]
  -ODBC_DSN:<str>	DSN
	text, CMD
  -ODBC_USR:<str>	User
	text, CMD
  -ODBC_PWD:<str>	Password
	text, CMD
  -SQL:<str>     	SQL Statment
	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:<str>  	Commit
	boolean
	Default: 1
  -STOP:<str>    	Stop on Error
	boolean
	Default: 0