DTM Database Tools Home  

DTM ODBC SQL runner

Download demo version right now!
How to buy DTM ODBC SQL runner?
 
DTM ODBC SQL runner icon

DTM ODBC SQL runner Overview

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. Download: 32 bit and 64 bit. No installation is required.

Usage:
sqlrun [optional parameters] [space-delimited file names]

Parameters:
-I[<configuration file name>]

  • by default the tool uses sqlrun.ini file in 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<ODBC Data Source Name>

-U<user name>

-P<password>

-O<standard output file name>     (the tool uses terminal output by default)

-L<log file name>     (the tool uses terminal output by default)

-S<SQL script file name>

-T<immediate SQL statement specification>

Important: command line parameter overwrites configuration 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>
Delimiter=<"tab" can be specified as '\t'. No delimiter means "fixed width" output.>
OverwriteOutput=<0|1> for 'append' or 'overwrite' output file
OverwriteLog=<0|1> for 'append' or 'overwrite' log file

[Script]
File=<files specification>
or
Statement=<immediate SQL statement specification>

See also: end user license agreement.

DTM ODBC SQL runner screenshot
 
Should I order business license of the tool?
Yes, if you:
  • need professional technical support
  • use more than 5 copies of the tool in your company
  • want to install the tool in bulk manner automatically
 
 

Copyright © 2004-2014 DTM soft. All rights reserved. Privacy policy.