Online Documentation for SQL Manager for DB2

View procedure changes


If you have modified a procedure and want to view committed changes then you need to do the following:

  1. Right-click this procedure in the DB Explorer.
  2. Select Change management | History item from the popup menu. You will see a table of object changes history.
  3. Select two procedure revisions you need to compare.
  4. Right-click any of the objects to call the context menu and select the Compare Properties or Compare DDL item to view differences as table of properties or as object script respectively.
  5. If you are comparing properties then in the window appeared you will see a table containing all procedure properties and its value in compared revisions. Properties with different values are highlighted with grey.
  6. If you are comparing DDL then in the window appeared you will see DDL of procedures revisions. Extra lines in an early revision script are red, in latter revision - grey. Lines for pasting missing lines are yellow and different lines are blue.