I am a new pervasive user and wanted to get a solution to my problem.

I want to query data in pervasive database and then generate an XML file output in a specific format. Is there a command line utility in Pervasive database that allows me to write PL/SQL script to do that and allow me to run the script nightly.

Is there any other scripting language used ? What is the command line utility ?

What are other alternatives available to accomplish this ?

Thanks for your help.

Regards

PSQL doesn't have any function or tool to export a dataset to XML.
You can either write your own tool to read the data and write it in XML or use a tool like the Pervasive Integration tools.

Thanks Mirtheil for your quick response.

Is there a way to write a query in Pervasive version 9 and out put in a flat file ? If yes how is it done ?

Can we also format or manipulate query to add tags in the ouput flat file.

Thanks

Yes and no. PSQL v9.5 has an Export Wizard but it only exports to a SDF (Comma Separated) file or an "Unformatted" file.

There isn't a tool included with PSQL that will do what you want. You'll need to build, have built, or buy a third party tool.