Promote

Package - Object Comparison SQL

Use this page to:

To access this page:

  1. Click Packages in the Navigation pane.
  2. Click the Packages icon for a Package Group.
  3. Click the SQL Objects icon for a Package.
  4. Click one of the links in the columns to view the comparison for that column (NOT IN DEST, DIFFERENT, SAME, QUEUE, ALL). For example, click the link in the NOT IN DEST column to access the page with data that shows where the SQL object is not included in the destination system after the comparison has been run.

  5. Click the Compare SQL icon for an Object Name.

    OR

  1. Click Approval in the Navigation pane.
  2. Click the View Package icon for a package group approval request.
  3. Click the SQL Objects icon for a Package.
  4. Click one of the links in the columns to view the comparison for that column (NOT IN DEST, DIFFERENT, SAME, QUEUE, ALL). For example, click the link in the NOT IN DEST column to access the page with data that shows where the SQL object is not included in the destination system after the comparison has been run.
  5. Click the Compare SQL icon for an Object Name.

Field

Description

DATABASE

Displays the database that stores the object specified in the SQL object name field.

OBJECT NAME

Displays the name of the SQL object.

HOST SQL CODE

Displays the SQL code for the object as it exists in the host database.

DEST SQL CODE

Displays the SQL code for the object as it exists in the destination database.