Goldstar Logo
Your Source for Actian Zen and PSQL Database Products, Services and Training Since 1997 EMail: Sales@goldstarsoftware.com 
Phone: 1-708-647-7665 
Web Site Login 
Free PSQL Support
Quick Links
Database Engines
 Version Quick-Reference Chart
+ Actian Zen v16
+ Actian Zen v15
+ Actian Zen v14
+ Actian Zen/PSQL v13
+ Actian PSQL v12
+ Actian PSQL v11
+ Pervasive PSQL v10
+ Pervasive PSQL v9
+ Pervasive.SQL V8
+ Pervasive.SQL 2000i
+ Pervasive.SQL 7
+ Btrieve 12
+ Btrieve 6.15
+ Actian Vector

+ Protecting Your Data

+ Goldstar Services

+ Goldstar Tools

+ Developer Resources

+ Other Solutions

Using AMS? Status 7224 Fix My PSQL License Report Engine Crash Repair PSQL Files Get Support Now Join Our Mailing List

Navigation Background

  Utilities Quick Links
Complete Tools List
BtrvInterceptor
DXUtil Page
GSSync Page
KeyCheck Page
LogSplitter Page
PSConfig Page
SQLExec Page
SQLInterceptor
Data File Recovery Toolkit
ViewUNF Page

Goldstar Software Utilities: SQLExec

Command-Line SQL Command Executor & Exporting Tool
License Type
Price (USD)
Links
Single User
$200
Buy Now
Site License
$800
Buy Now
30-Day Trial
Free
Try Now

SQLExec is a Win32 command-line application that accepts SQL statements or script files and executes each statement in the ODBC environment, on any accessible database server. Originally written for supporting command-line access to Pervasive.SQL, it can also be used on other ODBC databases, and has been tested in both Oracle and SQL Server environments.

SQL query statements are executed directly from the command line or from a script file, and the results are displayed as either fixed or delimited text (with many delimiter options built in). A header row can be included if needed, and trailing blanks in fields can automatically be truncated as well. The results can easily be redirected to a file for quick data exports, as well.

Since SQLExec supports running DDL statements as well as query statements, SQLExec is a very easy way for developers to script their application installation so that it automatically creates database files on-site, eliminating the need to ship populated DDF's and data files. (Note: Developers using PSQLv9 or newer may also wish to try out the free PVDDL tool included with the database.)

SQLExec also supports basic INSERT statement capabilities, so you can use it to load comma-delimited data into a data file as well as run other processes.

As a command line tool, SQLExec can easily be scheduled by any command scheduler (such as AT or SCHTASKS, included with most operating systems. This allows you to execute stored procedures or SQL-based reports or extracts on a timed basis.

SQLExec can be purchased as a single-user license or as a LAN site license. We can also provide licensing information for developers if you are interested in including SQLExec within your application for use for initializing databases or performing other maintenance tasks. Click the links above, or contact us for more details!

  Copyright © 1997-2024, Goldstar Software Inc., All rights reserved. PRODUCTS | SERVICES | TRAINING | SUPPORT | DOWNLOADS | ABOUT US  
Goldstar Software Inc. | 1945 Maplewood Ln | Munster IN 46321 Legal Statements | EULAs | Uninstall | Privacy Statements | Contact Us