PDREP95 and PDREPDIV

Contents:
    PDREP95
    PDREPDIV
    Other PowerDesigner versions

PDREP95 and PDREPDIV are two tool that reads an HTML report produced by PowerDesigner. PDPEPDIV reads reports generated by PD 6.1 and PDREP95 reports generated by PD 9.5. The reports must have been generated by the report templates HTMLREP.RTP (PDREPDIV) and HTMLREP951.RTP (PDREP95) located in the MISC directory of the AbaPerls installation.

Command-line syntax:

   prdrepdiv report [directory]
   pdrep95 report

report Is the file name you specified to PowerDesigner when you generated the report.
directory Is the directory where PDREPDIV is to put the generated HTML files. The default is the current directory.

PDREP95

The HTML reports generated by PowerDesigner 9.5.1 are quite versatile, but they do include a fair deal of white noise. PRDEP95 reduces that white noise by removing sections with no actual contents, and collapsing index and key documentation into one table each.

PDREP95 handle views and stored procedures. However, support for them are not (yet) included in HTMLREP951.RTP.

If there is a file, FOOTER.HTML in the current directory, PDREP95 will add that file to the end of each file. (In difference to PDREPDIV, there is no support for background pictures.)

Important: Prior to generating your reports, you must set two registry keys:

HKEY_CURRENT_USER\Software\Sybase\PowerDesigner 9\General\NbRowInHtmlList 5000
HKEY_CURRENT_USER\Software\Sybase\PowerDesigner 9\General\NbSubPageInHtmlList 2000

Else, PowerDesigner will break up the reports for big tables on several pages. (If this still happens to you, increase these numbers.) Unfortunately, these numbers are not settable from the PowerDesigner GUI.

When you run PDREP95, the tool prints the name of the file it's currently handling. PowerDesigner

Parsing a generated report, is a bit of a guesswork, but of PDREP95 goes out of sync, it tries to copy the existing report for an object as-is.

To see an example of the output from PDREP95, see the documentation for the AbaPerls system tables. This report was generated from the files ABAPERLS.PDM  and FOOTER.HTML in the DOC/DATABASE directory.

PDREPDIV

The HTML reports generated by PowerDesigner 6.1 are very rudimentary. They consist of a title page, a second page, and then one page which includes all domains, views, stored procedures and tables. PDREPDIV reads this big page and splits it so that you in directory get five files and four directories:

MAIN.HTML Home page for the model, with text taken from Model Properties in PowerDesigner.
TYPELIST.HTMLList of all domains in the data model.
TABLELIST.HTMLList of all tables in the data model.
PROCLIST.HTMLList of all stored procedures in the data model.
VIEWLIST.HTMLList of all views in the data model.
TYPEIn this directory there is one file for each domain in the model.
TBLIn this directory there is one file for each table in the model.
PROCIn this directory there is one file for each stored procedure in the model.
VIEWIn this directory there is one file for each view in the model.

PDREPDIV will not generate any list or directory for stored procedure or views if there are no such items in the model.

PDREPDIV also performs these changes:

PDREPDIV can include a background picture and footer for you:

In both these files, if you refer to files in the target directory, prepend the path with "./"; PDREPDIV will adjust this for the pages in the subdirectories. Likewise for "../".

Other PowerDesigner versions

As of this writing, the latest version of PowerDesigner is version 10. PDREPDIV will only work on reports from PowerDesigner 6.1, as later versions have a completely different format. PDREP95 may work on reports generated by other versions of PowerDesigner, as long you use the HTMLREP951.RTP template, but  I have not tested this, and the scenario is by no means supported.