Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    84

    Unanswered: DB2 application objects (binding)

    1. Is it possible to create application objects ( sp,UDFs) in a schema and bind them with objects (tables,views) belonging to a different schema (without explicitly qualifying the table objects within the codes of the objects ) ?
    If it is possible then how to go about it for SPs and UDFs?

    When I do a put routine it creates the object in the current schema using the tables of the current schema ( though the owner of the sp can be different).

    Any help is much appreciated.

  2. #2
    Join Date
    Sep 2003
    Posts
    84
    Forgot to mention - UDB V8.1 on AIX

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •