You can use the compare editor to compare and merge the source
code of routines that are stored in a data development project.
Prerequisite: Before you can compare and merge routines,
you must create more than one routine in a data development project.
These instructions describe how to compare and merge the source
code for routines that are stored in a data development project. You can also
compare routines at a file (*.spxmi) level by right-clicking two routines
and selecting . However, comparing and merging at a file
level is error-prone and is not recommended.
To compare and merge routine
source code:
- Switch to the Data perspective.
- Right-click two routines of the same type, and select . You can select two routines that are stored in
two different data development projects. However, the routines must be of
the same type. For example, you can compare two SQL stored procedures, but
you cannot compare an SQL stored procedure to a Java™ stored procedure. The
compare editor opens.
- Use the toolbar icons in the compare editor to merge changes from
one routine to the other, then press Ctrl + S to save your changes. You can also make changes by typing directly in the compare editor.
The changes that you made in the compare editor are added to each
routine.