Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    25

    Unanswered: Stored Procedure doesn't show in Control Center

    Hi All:

    I have created a Stored Procedure directly from the Command Window. It
    is OK and when I invoke it, everything is OK. But I don't see it on the
    Control Center. (BD-> App.Obj -> Stored Procedures) I try to refresh,
    quit from Control Center, but still Control Center doesn't show my SP.
    I have DB2 V8.1 for Windows.

    Any Ideas? Thanks...!

  2. #2
    Join Date
    Jan 2004
    Posts
    30
    experienced the same problem in DB2 Version 8.1 Personal Edition for windows. i created the procedure through DB2 command window, the same is not listed in DB2 Control center. Procedure name which i had created is more than 18 characters.
    And my question is, whether length of the procedure name is problem with this one?

    help

  3. #3
    Join Date
    May 2004
    Posts
    2

    Thumbs up Can you provide the example of your stored procedure

    Can you post your stored procedure here exactly as you typed it into command centre together with exact failed compile message you received please

    Thanks
    Last edited by marklee55; 05-06-04 at 08:57. Reason: typo

  4. #4
    Join Date
    May 2004
    Posts
    25

    Unhappy

    Hello:
    Here is the code. Is quite simple.

    CREATE PROCEDURE DRR.PROCEDURE1 (INOUT var0 varchar(50) )
    LANGUAGE SQL

    P1: BEGIN
    DECLARE cursor1 CURSOR WITH RETURN FOR
    Select ope_nombre from preventa.prvoperadores;
    END P1

Posting Permissions

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