Developing SQL Stored Procedures from the Development Center


When the launchpad is used to create a new project, the Options tab has information specific to DB2 for zSeries, as shown in Figure D.32.

Figure D.32. Launchpad options specific to DB2 for zSeries.


In the Package Owner field, you can type the authorization ID of the owner of the DB2 package that will be stored in DB2 for zSeries containing the SQL of the stored procedure. This owner should have the appropriate privileges to execute the SQL in the stored procedure. If you leave this field blank, the ID used to connect to the database is used as the default.

In the Build Owner field, you can type the authorization ID of the person or group in charge of building, rebuilding, and dropping a stored procedure. You can type a secondary authorization ID or a group name if you want several users to share this responsibility. If you leave this field blank, the ID used to connect to the database is used as the default.



    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