Need to Query a Pervasive 9.X DB

[SINNER]

I need to query a pervasive 9.X DB and have the output to a txt or CSV
file. I tried using the internal pvddl tool but it seems to just
create/update ddf files in the database folder. (this is a transactional
not relational DB)

Optimally Id like to output in a specific format rather than just TXT or
CSV to meet a clients needs but If I could just get the data out for now I
can work that out. Any help appreciated.

--
David

[mehoss]

If the trial versions are still available, download it It should
install crude tools to access the database via sql also It should
install an ActiveX interface. If you want to get fancy with the data,
Then use the ActiveX interface in any
Microsoft VBScript macro capable product or visual studio or any
other
ActiveX capable programing language to get the data
Worked for me several years ago

[BtrieveBill]

If you are doing this manually, then you can use the included Pervasive
Control Center. Just right-click on the table in the PCC and select Export.

If you need this to be command-line driven, or include additional export
options, then you may want to look at an external tool. Our own SQLExec
(www.goldstarsoftware.com/sqlexec.asp) is a good start, and it allows
you to run extracts from the command line (like PVDDL, but with real
output) in a wide variety of export formats.

Of course, ANY ODBC-compliant export tool will also work for you, so if
you have an ETL program, like Informatica, Pervasive Data Integrator, or
the like, they will work quite well, too.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
Bill...@goldstarsoftware.com
http://www.goldstarsoftware.com
*** Pervasive Training - October 2009 in Chicago ***

[SINNER]

* BtrieveBill wrote in comp.databases.btrieve:

> If you are doing this manually, then you can use the included
> Pervasive Control Center. Just right-click on the table in the PCC
> and select Export.
>
> If you need this to be command-line driven, or include additional
> export options, then you may want to look at an external tool. Our
> own SQLExec (www.goldstarsoftware.com/sqlexec.asp) is a good start,

Your software was the first thing I found. The issue for me is that I need
to provide a solution to a client that is already going to come at a cost.
The application is client server based and installed at a number of sites
so licensing is going to be an issue.

> and it allows you to run extracts from the command line (like PVDDL,
> but with real output) in a wide variety of export formats.
>
> Of course, ANY ODBC-compliant export tool will also work for you, so
> if you have an ETL program, like Informatica, Pervasive Data
> Integrator, or the like, they will work quite well, too.

Thanks Bill, I went with a freeware option that I found that allowed me to
complete the task. I appreciate the answer.

--
David