Tool Import Table from SQL Query

Import a SQL table from a database via ODBC.

Author: O.Conrad (c) 2008
Menu: Database|ODBC|Tables

Parameters

	Name	Type	Identifier	Description	Constraints
Output	Table from SQL Query	Table (output)	`TABLE`	-	-
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
	Tables	Text	`TABLES`	-	-
	Fields	Text	`FIELDS`	-	Default: *
	Where	Text	`WHERE`	-	-
	Group by	Text	`GROUP`	-	-
	Having	Text	`HAVING`	-	-
	Order by	Text	`ORDER`	-	-
	Distinct	Boolean	`DISTINCT`	-	Default: 0

Command-line

Usage: saga_cmd db_odbc 8 [-ODBC_DSN <str>] [-ODBC_USR <str>] [-ODBC_PWD <str>] [-TABLE <str>] [-TABLES <str>] [-FIELDS <str>] [-WHERE <str>] [-GROUP <str>] [-HAVING <str>] [-ORDER <str>] [-DISTINCT <str>]
  -ODBC_DSN:<str>	DSN
	Text
  -ODBC_USR:<str>	User
	Text
  -ODBC_PWD:<str>	Password
	Text
  -TABLE:<str>   	Table from SQL Query
	Table (output)
  -TABLES:<str>  	Tables
	Text
  -FIELDS:<str>  	Fields
	Text
	Default: *
  -WHERE:<str>   	Where
	Text
  -GROUP:<str>   	Group by
	Text
  -HAVING:<str>  	Having
	Text
  -ORDER:<str>   	Order by
	Text
  -DISTINCT:<str>	Distinct
	Boolean
	Default: 0