Stored Procedure Run Settings

Additional Run options are available in the Development Center (see Figure D.24).

Figure D.24. Setting stored procedure settings.

By changing the run settings of a procedure, as shown in Figures D.24 and D.25, you have the option of not having any changes committed. With this option, after a procedure has finished executing all changes will be automatically rolled back. This is useful for keeping the state of the database consistent while you debug your code. Scripts can also be set to run before or after the procedure executes. This gives you greater control over the testing environment of stored procedures.

Figure D.25. Setting stored procedure Run options.

    DB2 SQL PL. Deployment and Advanced Configuration Essential Guide for DB2 UDB on Linux., UNIX, Windows, i5. OS, z. OS
    Intelligent Enterprises of the 21st Century
    ISBN: N/A
    EAN: 2147483647
    Year: 2003
    Pages: 205 © 2008-2017.
    If you may any questions please contact us: