Southsoftware.com
.:Pricing
Home
Products
Downloads
Support
Contacts
Site Map
.:Advanced Task Scheduler
About product
Download trial
Purchase license
Compare editions
View screenshot
FAQ & Support
Press Kit
.:Articles
Online manual
Blog posts
Videos
More articles...
.:Follow us
Follow us on Facebook Follow us on Twitter Follow us on YouTube
   

ODBC SQL

This shortcut type allows executing a SQL Query via ODBC data source (Professional and Network Editions only).

If a query is a SELECT statement that returns a set of rows as output, the output will be saved in the execution log. The number of rows will be returned in the Exit code. The number of rows is the sum of number of rows affected by each query, if no rows are affected, then the number of rows in the output.

Connection string
An ODBC data source or ODBC driver connection string. ODBC connection string varies for different ODBC drivers. Please consult with your ODBC driver manual for ODBC connection string format.

SQL queries
A set of SQL queries that will be executed one by one. Queries must be properly escaped according to the database rules. Each query will be passed to the driver in Unicode. It is the driver’s responsibility to encode and collate the query.

SQL Options

Treat output charset as
Character set of the output data. This option does not affect SQL query. For example, you can pass the “Charset=UTF8;” attribute to MySQL ODBC Driver to receive output in UTF8.

Use maximum length of field
If the field data is longer than the specified length, then the data will be truncated.

Use timeout
Timeout of the operation, in seconds.

Returning codes
Error code: Error code of starting the command
Exit code: Number of rows

Related Articles
SQL Automation with Task Scheduler

Categories: Manual, Shortcut type

   
About us   Privacy policy   Terms of use   Link to us
Current Version: 4.5.0.616
The following prices are based on a single order:
Basic Edition 32 and 64-bit$ 39.95 USD
Professional Edition 32 and 64-bit$ 59.95 USD
Network Edition 32 and 64-bit$ 149.95 USD
.:Testimonials

I use Advanced Task Scheduler to run my backups jobs. After performing a backup by standard Windows 2003 Server means, Advanced Task Scheduler launches a script which copies files. I am glad I chose your program.

Rob Hannigan

.:Requirements
Computer: Minimum required by operating system you are running.
Disk Space: Under 30 MB
Operating System: Microsoft Windows 32-bit or 64-bit.
Read more...