DTM ODBC SQL runner
Run your scripts easy
DTM ODBC SQL runner icon

Command Line SQL Statement Execution Tool 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. It is a Windows application that supports Windows XP/Vista/7, Windows 8/10 (desktop), Server 2003/2008/2012.

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
NullIsEmptyString=<0|1> The program uses empty string instead of NULL if the option is '1' or 'true'
QuoteChar=<symbol for unconditional value quoting, empty (no quote) by default>

[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.
  • Want to redistribute the tool with your own solution.

Order Business License.
Copyright © 2004-2015 DTM soft. All rights reserved. Privacy policy.