Import Table from Query

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

Description

Import a table from a database through ODBC via SQL query. > SELECT [DISTINCT|ALL] 'Fields' FROM 'Tables' WHERE 'Where' [GROUP BY 'Group' [HAVING 'Having']] [ORDER BY 'Order']

Parameters

	Name	Type	Identifier	Description	Constraints
Output	Table	table, output	`TABLE`	-	-
Options	Data Source	text, CMD	`ODBC_DSN`	-	-
	User	text, CMD	`ODBC_USR`	-	-
	Password	text, CMD	`ODBC_PWD`	-	-
	Tables	text	`TABLES`	-	-
	Fields	text	`FIELDS`	-	Default: *
	Where	text	`WHERE`	-	-
	Group	text	`GROUP`	-	-
	Having	text	`HAVING`	-	-
	Order	text	`ORDER`	-	-
	Distinct	boolean	`DISTINCT`	-	Default: 0

Command Line

Usage: saga_cmd db_odbc 8 [-ODBC_DSN ] [-ODBC_USR ] [-ODBC_PWD ] [-TABLE ] [-TABLES ] [-FIELDS ] [-WHERE ] [-GROUP ] [-HAVING ] [-ORDER ] [-DISTINCT ]
  -ODBC_DSN:	Data Source
	text, CMD
  -ODBC_USR:	User
	text, CMD
  -ODBC_PWD:	Password
	text, CMD
  -TABLE:   	Table
	table, output
  -TABLES:  	Tables
	text
  -FIELDS:  	Fields
	text
	Default: *
  -WHERE:   	Where
	text
  -GROUP:   	Group
	text
  -HAVING:  	Having
	text
  -ORDER:   	Order
	text
  -DISTINCT:	Distinct
	boolean
	Default: 0