Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Bangalore
    Posts
    36

    Unanswered: How to catalogue a stored procedure

    I am creating a stored procedure using command center but it is not getting catalogued. I mean when I open the control center the newly created stored procedure is not visible under the "Application Object-> Stored Procedures" even if I refresh the panel.
    How to catalogue the Stored Proc? I need catalogued stored proc because my DB2 Type 4 JDBC driver does not support access of uncatalogued stored procedure.

  2. #2
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Hi,

    Can you atleast check for the DLL created for the particular procedure in the \\program files\sqllib\function\routine\sqlproc\dbname folder.

    If this DLL is present then i guess you can directly call the procedure.

    cheers,
    Prashant

Posting Permissions

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