You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
Menu
Subscribe to BAOA
- New APEX Item Type Plugin : BetterGrow Textarea
- Creating a Cool Dashboard in APEX
- UKOUG 2010 Recap - Wednesday
- Get Your Workshop Hands On! New Developer Day Cities/Dates
- TechCast Live: Java and Oracle, One Year Later (Feb. 15, 10am PT)
- Live Webcast: Managing Oracle Exadata with Oracle Enterprise Manager 11g (Feb. 10, 10am PT)
- Oracle Introduces Oracle Cloud File System for Private Clouds
- Mixing C and C++ Code in the Same Program
Extending DDDAUDIT functionality
Running the DDDAUDIT.SQR process is something every PeopleSoft administrator should do on a regular basis, because it detects flaws between objects in the database and the corresponding definitions in the PeopleSoft data dictionary.
In normal maintenance life however this process doesn’t run that often, so the output can be quite large. Also, when running a DDDAudit during upgrades, there can be a lot of records (TABLE-3 check) and views (VIEWS-2 check) that are obsolete in the new version thus have to be removed. These objects have to be removed manually, which can be a lot of work.
By adjusting the DDDAudit script a bit this work can be reduced a lot. The trick is to write a drop statement to a new file after the record or view that has to be deleted is printed to the output report.
I’ll illustrate it by adding the necessary code to the TABLE-3 check for a Microsoft SQL Server database. In the dddtable.sqc file (which is called from the dddaudit.sqr) add the following lines:
In this case for every table found in the TABLE-3 check a drop statement is written to the file c:tempaz_drop_table3.sql. This file will look like this:
The only thing you have to do now is run this script. You can also add code like this to the VIEWS-2 check in the dddviews.sqc file (or any check you like) to drop views defined in the database but not in de Application Designer.
Viewed 5403 times by 1546 visitors
Related posts: