Odbc sql query tool
DTM ODBC SQL runner is a command line tool that allows the user to run SQL statements using specified ODBC data source (DSN). It is most suitable for batch and scheduled execution. It is a Windows application that supports Windows XP/Vista/7, Windows 8/10 (desktop), Server 2003/2008/2012.
Usage
sqlrun [optional parameters] [space-delimited file names]
Parameters
-I
- by default the tool uses sqlrun.ini file in the program directory.
- empty arguments list means -I
- '*' and '?' are acceptable in SQL file name
- see configuration file format below
- it is strongly recommended to specify -I as the first command line parameter
-H
(add column header to output file).
-Q
(shows actual parameters loaded from configuration file or assigned by command line switches).
-D
-U
-P
-O (the tool uses terminal output by default)
-L (the tool uses terminal output by default)
-S
-T
Important: command line parameter overwrites configuration file value.
Configuration File Format
[Connection]
DSN=
User=
Password=
[Settings]
Output=
Errors=
Header=
Delimiter=
OverwriteOutput= for 'append' or 'overwrite' output file
OverwriteLog= for 'append' or 'overwrite' log file
NullIsEmptyString=|1> The program uses empty string instead of NULL if the option is '1' or 'true'