Usage: IN TableName [InFileName[.txt]] [LogFileName[.log]]
Inserts rows from InFileName (a tab-delimited text file) INTO TableName.
If -u switch is used, columns are backslash unescaped.
Character fields containing an empty string are imported as NULL.
Usage: OUT [TableName | *] [OutFileName[.txt]] [LogFileName[.log]]
Writes rows from TableName to OutFileName as tab delimited text.
VarChar, and LongVarChar columns are escaped for ASCII 8-13 (and \) with:
\b\t\n\v\f\r
Character fields which are an empty string are output as a single space.
NULL Character fields are output as an empty string, by default (see -nt)
If any FileName is not given, or CON, standard output is used.
If In or OutFileName is not given, defaults to TableName with .txt extension.
Options: (case sensitive, may be preceeded with a - or /)
-cs Driver Connect String (if -cs is used -d -db -U and -P are ignored)
-a Abort on error (default is continue execution on error).
-d ODBC Data Source Name
-db Database Name (override Database defined in DSN)
-i Initialization File
-U login
-P password
-nt NULL_Token
NULL_Token is by default an empty string and is written in OUT mode
when column is NULL (Note: this is NOT used in IN mode).
-Q "(SQL statement here)" -or- file:filename.sql (IN mode only)
-v Verbose mode, write SQL_SUCCESS_WITH_INFO messages to log
-h Header row (default)
-s FileName - Script file (write SQL script)
When this option is given, OutFileName is name of a tab-delimited text file
containing the columns to be exported as SQL. Only the first line is read.
Example: SQLData -s FileName.sql OUT TableName Header.txt
-t Right trim blanks from data (default)
-t- Do NOT right trim blanks from data
-u Unescape import data
-? help (this screen)
-help (this screen)
Any parameter containing spaces should be surrounded by double quotes.
A minus sign after the option turns it off (example: -h- for No Header row).
Current directory and program directory is checked for SQLData.ini
which is a text file in the form: Option=OptionValue example:
d=Data Source Name
An initialization file may specified on the command line like this: @MyFile.ini
Login and password optional if DBMS supports trusted connections.
Version 1.2 http://www.incodesystems.com
To see complete usage, type: SQLData /? | MORE
Incode Systems, Inc.