Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Is there a way to get SQL CRUD information from a project using Analysis Tools?

Is there a way to get SQL CRUD information from a project using Analysis Tools?

Problem:

There is a great need to extract from a project the SQL CRUD table information.  How would this be done using the Analysis tools that Revolve supplies today?

Resolution:

Attached to this KB is a zip file that contains many analysis tools.  Below is how to work with it.

This toolset was created to help the user analyze their SQL project and retain the SQL CRUD information.  The output could be exported to an Excel spreadsheet.

1.

Unzip this file into your Revolve 7.0 directory (using folder names).  

2.

Copy the sqlcrud.xls from the config\reports folder to c:\rv folder.

3.

Go to Revolve 7.0 and open the project to run the toolset.

4.

Go to Enterprise/Analysis Tools.

a.

Note that if this project has been open prior to unzipping these tools then it is necessary to go to Options/Tool Palette Editor to add these tools (highlight the left panel, press "Add Selected" button, press OK)

5.

Run "Report: SQL Crud" - change properties as follows:

a.

Report type - "comma separated values"

b.

Display output - "Display + File"

c.

Filespec to send output to - default value

6.

Go to C:\rv folder and Open sqlcrud.xls

7.

On "Revolve EE Report" tab choose drop down "Data/Refresh Data"

8.

Browse for c:\rv\sqlcrud.txt and import

9.

go to "Formatted CRUD" tab, select cell A4

10.

Right-click, choose "Refresh Data"

11.

To drill down on actual statement double-click on the number under the CRUD type and to the right of the column in question (a new sheet will be created in the workbook - tab will read Sheet1).

Have a look at the extra tools added to the tool palette.  These tools will find columns or tables by name pattern, find the associated columns/tables, etc.

The IMSSQLCRUD.zip file has additional scripts that need to be put in Revolve 7.0\config\scripts folder.

Attachments:

sqlcrud.zip

Old KB# 1078

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 16:55
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.