Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    2

    Unanswered: Create synonym for stored procedures?

    Could someone tell me how to go about creating a synonym for a stored procedure.

    It is possible in Oracle and wondered if it could be done in DB2.

    Or, is there some way to execute a stored procedure that exists in a different schema without using the qualifier.

  2. #2
    Join Date
    Jul 2001
    Posts
    32
    Synonym can't be created for stored procedures on DB2 UDB. For other objects like table,etc , synonym can be created. Only with stored procedure schema name , it can be called. I think, there is no other way to call.
    Thanks,
    Thangam

  3. #3
    Join Date
    Nov 2002
    Posts
    2

    Smile

    Thanks very much.......



    Originally posted by thangam
    Synonym can't be created for stored procedures on DB2 UDB. For other objects like table,etc , synonym can be created. Only with stored procedure schema name , it can be called. I think, there is no other way to call.
    Thanks,
    Thangam

Posting Permissions

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