The INVOKE Behavior


The INVOKE Behavior

As mentioned earlier, the invoker is the user who will execute or invoke the procedure. Consider the following characteristics for invoking the procedures:

  • DB2 uses the authorization ID of the user-defined function or stored procedure invoker for authorization checking of dynamic SQL statements in the application package. If the invoker is the primary authorization ID of the process or the CURRENT SQLID value, secondary authorization IDs are also checked if they are needed for the required authorization. Otherwise, only one IDthe ID of the invokeris checked for the required authorization.

  • The default qualifier for unqualified objects is the user-defined function or stored procedure invoker.

The corresponding DYNAMICRULES bind/rebind options for the define behavior are the following:

  • DEFINEBIND. Processes dynamic SQL statements with the DEFINE behavior for stored procedures and functions, and with the BIND behavior when the package is run as a stand-alone program.

  • DEFINERUN. Processes dynamic SQL statements with the DEFINE behavior for stored procedures and functions, and with the RUN behavior when the package is run as a stand-alone program.

  • INVOKEBIND. Processes dynamic SQL statements with the INVOKE behavior for stored procedures and functions, and with the BIND behavior when the package is run as a stand-alone program.

  • INVOKERUN. Processes dynamic SQL statements with the INVOKE behavior for stored procedures and functions, and with the RUN behavior when the package is run as a stand-alone program.



    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

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net