SAGA-GIS Tool Library Documentation (v7.7.0)

Tool Import Table from SQL Query

Import a SQL table from a database via ODBC.

Parameters

 NameTypeIdentifierDescriptionConstraints
OutputTable from SQL QueryTable, outputTABLE--
OptionsDSNText, CMDODBC_DSNData Source Name-
UserText, CMDODBC_USRUser Name-
PasswordText, CMDODBC_PWDPassword-
Server ConnectionChoice, GUICONNECTIONServer ConnectionAvailable Choices:
Default: 0
TablesTextTABLES--
FieldsTextFIELDS-Default: *
WhereTextWHERE--
Group byTextGROUP--
HavingTextHAVING--
Order byTextORDER--
DistinctBooleanDISTINCT-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, CMD
  -ODBC_USR:<str>	User
	Text, CMD
  -ODBC_PWD:<str>	Password
	Text, CMD
  -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