If you develop your IBM® SQL or SPL routines and database objects in an IBM database project, you can edit their source code in the Visual Studio Code Editor. The editor supports cut, copy, paste, find and replace, menu and keyboard shortcuts, and syntax highlighting.
If you open a project that contains scripts for existing SQL or SPL procedures or functions, or objects, you can modify the source code (including SQL or SPL statements) in the editor. You can use the IBM® Database Add-Ins for Visual Studio to drop the old procedure, function, or object from the database and create a procedure, function, or object that reflects the changes that you made. You can also edit the procedure, function, or object. If your script file does not contain a drop statement or does not use an alter statement, attempting to build that script twice will cause a duplication error.
Editing the source code of overloaded procedures that are based on
data type produces undefined results.
To edit the source code of a procedure, function, or object:
The source code of the procedure, function, or object opens in the editor.
Reviewing and Updating Scripts for Procedures, Functions, or Objects | Managing Procedures, Functions, and Objects