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

If the trial versions are still available, download it  It should
install an ActiveX interface.  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.

On Oct 21, 2:03=A0pm, SINNER <arcade.mas...@gmail.com> wrote:
> 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

On Oct 21, 2:03=A0pm, SINNER <arcade.mas...@gmail.com> wrote:
> 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

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

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
	BillBach@goldstarsoftware.com
	http://www.goldstarsoftware.com
	*** Pervasive Training - October 2009 in Chicago ***


SINNER wrote:
> 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.
> 

* 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