SAGA 9.9.1 | Tool Library Documentation

Export Table


Description

Exports a table to a database via ODBC.


Parameters

 NameTypeIdentifierDescriptionConstraints
InputTabletable, inputTABLE--
OptionsData SourcetextODBC_DSN--
UsertextODBC_USR--
PasswordtextODBC_PWD--
Primary Keytable fieldsTABLE_PK--
Not Nulltable fieldsTABLE_NN--
Uniquetable fieldsTABLE_UQ--
Table NametextNAME--
If table exists...choiceEXISTS-Available Choices: [0] abort export [1] replace existing table [2] append records, if table structure allows Default: 0

Command Line


Usage: saga_cmd db_odbc 6 [-ODBC_DSN ] [-ODBC_USR ] [-ODBC_PWD ] [-TABLE ] [-TABLE_PK ] [-TABLE_NN ] [-TABLE_UQ ] [-NAME ] [-EXISTS ]
  -ODBC_DSN:   Data Source
	text
  -ODBC_USR:   User
	text
  -ODBC_PWD:   Password
	text
  -TABLE:      Table
	table, input
  -TABLE_PK:   Primary Key
	table fields
  -TABLE_NN:   Not Null
	table fields
  -TABLE_UQ:   Unique
	table fields
  -NAME:       Table Name
	text
  -EXISTS:
                    If table exists...
                    	choice
                    	Available Choices:
                    	[0] abort export
                    	[1] replace existing table
                    	[2] append records, if table structure allows
                    	Default: 0