Odbc sql query tool

Command Line SQL Statement Execution Tool Overview
August 17, 2022 – 11:20 am
Odbc Sql Query Tool - Image Mag

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'

crowd fund business sdg apple education seed stage startup project management professional certification fundable crowdfunding scc10th result 2022 steve mariotti corporate training education for all life of an entrepreneur customer development steve blank crowdfunding healthcare crowdstreet non accredited investor entrepreneurial marketing strategies care courses access to capital for entrepreneurs hbse 12th result 2022 up board result linkedin courses crowdfunding citymapper gender and development joey concepcion go negosyo national center for education statistics msc nursing impact guru office creatella meesho crunchbase african crowdfunding platforms up board 10th result 2022 ninjacart funding sustainable management pseb result fellow finance crowdfunding github education equity funding platforms mkcl ssc result 2022 best indiegogo campaigns 2022 startup studio anger management classes malaysian entrepreneur types of resources in entrepreneurship york courses sustainability entrepreneurship cryptocurrency crowdfunding platform
Source: www.sqledit.com
Related Posts