comparedictprocedures
comparedictprocedures
DATABASE
,
DICTIONARY
,
MODIFIED
,
NEW
,
REMOVED

The comparedictprocedures statement compares all the procedures from a dictionary with the procedures in a specified database.

Parameters

This statement has five parameters:

database – Name of the database, or “” for current database.

dictionary – Dictionary (built with the saveallprocedures statement)

modified – Field or variable to receive a carriage return delimited list of procedures that exist in both places but are not identical.

new – Field or variable to receive a carriage return delimited list of procedures that exist in the dictionary but not in the database.

removed – Field or variable to receive a carriage return delimited list of procedures that exist in the database but not in the dictionary.

Description

This statement compares all the procedures from a dictionary with the procedures in a specified database. It returns information about how the two lists differ.

Here is an example that saves a copy of all procedures in the current database into a global variable.

    global psave
    saveallprocedures psave

Here is a second example that can be run later to find out which procedures have been modified.

    local mp,np,rp
    comparedictprocedures "",psave,mp,np,rp
    displaydata
        "Modified:"+cr()+cr()+mp+cr()+cr()+
        "New:"+cr()+cr()+np+cr()+cr()+
        "Removed:"+cr()+cr()+rp

Note: Starting with Panorama X, you can use the File>Export>Blueprint feature and check the database blueprint into a git repository (or other svn). This allows you to track changes made to procedures (and other database elements) through the source version control system.

History

Version | Status | Notes
10.0 | No Change | Carried over from Panorama 6.0.