Export Table

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

Description

Exports a table to a database via ODBC.

Parameters

	Name	Type	Identifier	Description	Constraints
Input	Table	table, input	`TABLE`	-	-
Options	Data Source	text	`ODBC_DSN`	-	-
	User	text	`ODBC_USR`	-	-
	Password	text	`ODBC_PWD`	-	-
	Primary Key	table fields	`TABLE_PK`	-	-
	Not Null	table fields	`TABLE_NN`	-	-
	Unique	table fields	`TABLE_UQ`	-	-
	Table Name	text	`NAME`	-	-
	If table exists...	choice	`EXISTS`	-	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