Re: send Command line SQL query

#1

Hi, I don't know of anything like that for Pervasive.SQL. I do have an
application that has a few of the features of mysql.exe, though.

It uses ADO and takes input from an XML file and outputs to a window,
CSV, or XML. It also works for a few other databases. It's in beta
right now. If you're interested, I could send it to you to try out.

Wayne Freeman
Analytica Business Systems
A Pervasive Premier VAR
http://www.analyticabiz.com

seetickets ha scritto:

Quote:

Does anybody know if theres a way that you can send sql queries
straight to pervasive through a simple cli command?

For example in mySql you can just do "mySQL" from the command line then
login and it drops you at the "sql>" prompt. You can then just type
your queries and the results spewed out to the dos window.

Can you do this in pvsw?

#2

There is nothing like that shipped with the product.
There are several 3rd party tools that will do what you want.

See here:
http://www.pervasive.com/componentzone/
under the "Tools and Utilities" link currently on the 2nd page is
"PvQuery". It is the one I use. It has both interactive and batch
modes.

Leonard

On 6 Oct 2006 10:15:41 -0700, "seetickets" <glyn (AT) wayahead (DOT) com> wrote:

Quote:

Does anybody know if theres a way that you can send sql queries
straight to pervasive through a simple cli command?

For example in mySql you can just do "mySQL" from the command line then
login and it drops you at the "sql>" prompt. You can then just type
your queries and the results spewed out to the dos window.

Can you do this in pvsw?

#3

seetickets wrote:

Quote:

Does anybody know if theres a way that you can send sql queries
straight to pervasive through a simple cli command?

For example in mySql you can just do "mySQL" from the command line
then login and it drops you at the "sql>" prompt. You can then just
type your queries and the results spewed out to the dos window.

Can you do this in pvsw?

If you have Pervasive PSQL v9, the include PVDDL tool should be
sufficient to send DDL statements (i.e. statements that don't return
any data) to the database. This is what Pervasive's own installer uses
to build the DEMODATA database.

Our SQLExec tool is a Win32 Command-Line application that can handle
sending statements to the SQL engine (actually, to ANY ODBC interface).
It's not dynamic like your request, but the PCC allows you to do
dynamic SQL much more simply, so I've just never developed that feature
of it.

Let me know if you're interested in a trial copy.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 10/2006 ***

#4

You can pull a copy from here in the next few days...
ftp://ftp2.goldstarsoftware.com/sqlexec.zip
BB

seetickets wrote:

Quote:

Hi Bill,

A trial copy would be great, we'll give it a spin.

thanks
Glyn

Bill Bach wrote:
seetickets wrote:

Does anybody know if theres a way that you can send sql queries
straight to pervasive through a simple cli command?

For example in mySql you can just do "mySQL" from the command line
then login and it drops you at the "sql>" prompt. You can then
just type your queries and the results spewed out to the dos
window.

Can you do this in pvsw?

If you have Pervasive PSQL v9, the include PVDDL tool should be
sufficient to send DDL statements (i.e. statements that don't return
any data) to the database. This is what Pervasive's own installer
uses to build the DEMODATA database.

Our SQLExec tool is a Win32 Command-Line application that can handle
sending statements to the SQL engine (actually, to ANY ODBC
interface). It's not dynamic like your request, but the PCC allows
you to do dynamic SQL much more simply, so I've just never
developed that feature of it.

Let me know if you're interested in a trial copy.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 10/2006 ***

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: send Command line SQL query

comp.databases.btrieve comp.databases.btrieve

Re: send Command line SQL query - 10-06-2006 , 07:52 PM

Re: send Command line SQL query - 10-08-2006 , 10:45 PM

Re: send Command line SQL query - 10-10-2006 , 11:06 AM

Re: send Command line SQL query - 10-18-2006 , 08:24 AM