Export Query SQL to a Directory

Description

This project takes all queries with the naming convention of beginning with "GS" and exports the SQL to a directory on a file server.

It can be used for the following:

• Generating SQL for a DBA to review and run explain plans on
• Exporting to a version control repository to see how queries change over time.

This code is implemented as an Application Engine program so it can be run in batch, but can be modified to be run online.

Downloading the Project

Here is how you can download this project for your own use:

The current version of the PeopleTools objects can be installed in your environment using the following attachment . Here are the instructions for how the installers work. Also, at the bottom of this wiki page are attachments for the other revisions in the source code repository.

Any other objects can be downloaded directly from the pshome folder in the source tree

Bugs/Feature Requests

Existing bugs and feature requests for QuerySQLExport are here.

If you have any issues, create a new ticket (requires registration).

Source

You can browse through the source code here. The main code is in the Application Engine program GS_QRYSQL. If you'd like to install the project locally in your own environment, an installer is attached at the bottom of this page.

Registered users can check out QuerySQLExport from  here using Subversion.

Recent Changes

[27] by larry.grey on 2010/06/17 04:47:34

New Query Changes.

[26] by larry.grey on 2010/06/17 04:46:10

Initial State of Queries Exported

[25] by larry.grey on 2010/06/17 04:40:41

Changed to create files in proper version control directory.

[24] by larry.grey on 2010/06/17 04:39:08

Extended to process each query that begins with GS.