DB2 Server for VSE & VM: Interactive SQL Guide and Reference

Managing a Routine

Routines stored in a table are managed in the same manner as data in any table by using SQL UPDATE, INSERT, and DELETE statements.

For example, to modify the PRINTDEP routine (shown in Figure 43) to use a double bar instead of a single bar to separate columns, you can type:

   update routine -
   set command = 'format separator  '' || ''' -
   where seqno = 20 and name = 'printdep'

As another example, you can delete the entire QREPORT routine by typing:

   delete from routine -
   where name = 'qreport'