Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008
    Posts
    12

    Unanswered: Generating XML output in a specific format

    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

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    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.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Jan 2008
    Posts
    12
    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

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    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.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •