|
DTM ODBC SQL runner is a command line tool that alows the user to run SQL statements using specified ODBC
data source (DSN). It is most suitable for batch and scheduled execution.
Download: 32 bit and 64 bit. No installation is required.
Usage:
sqlrun [optional params] [space delimited filenames]
Params:
-I[<config file name>]
- by default uses sqlrun.ini in program directory.
- empty arguments list means -I
- '*' and '?' are acceptable in SQL file name
- see config file format below
-H
(add column header to output file, for 32 bit version only).
-D<data source name>
-U<user name>
-P<password>
-O<standard output file name>
- uses terminal output by default
-L<log file name>
- uses terminal output by default
Important: command line parameter overwrites config file value.
Configuration File Format
[Connection]
DSN=<data source name>
User=<user name>
Password=<password>
[Settings]
Output=<standard output file name>
Errors=<uses terminal output by default>
Header=<0|1>
[Script]
File=<files specification>
|