Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2004
    Posts
    448

    Unanswered: db2look no procedure statement

    The database is ver8 .

    export USER=<instance_owner>

    I am using db2look -d < database_name> -e

    It extracted functions from one schema , but no procedures
    from other schema.

    I also used db2look -d -z <schema_name> -e

    The only thing missing are procedures

    Is there anything needs to be changed

    regards

    Mujeeb

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You cannot get Stored Procedure using db2look. I guess it is because SPs can be written in other languages beside SQL.

    Andy

  3. #3
    Join Date
    Mar 2004
    Posts
    448
    db2look in ver8.2 have shown the create procedure command.
    I will check with other db2 version.
    It only shows the registered procedure command and it should be like
    that one.

    But it is showing the create function, function also calls the other external
    language program.

    regards

    Mujeeb

  4. #4
    Join Date
    Sep 2003
    Posts
    85
    Mujeeb,
    I beg to differ re. db2look outputting the CREATE PROCEDURE statements in UDB v8.2 .
    I do see the GRANT EXECUTE ON PROCEDURE ... statements but not the CREATE PROCEDURE statements.
    Ruby

  5. #5
    Join Date
    Mar 2004
    Posts
    448
    I just did db2look -d sample -e -o <output_file>

    The file has the create procedure statement, the registered part,
    my procedure are calling external library.

    regards

    Mujeeb

  6. #6
    Join Date
    Mar 2004
    Posts
    448
    I don't know its an odd behaviour or some changes in ver8.2.

    I created an SQL stored procedure.
    When I used db2look to extract information, it shows the registered part,
    then add clause of external name, language remains the same SQL.
    No procedure body part.
    I know that with ver 8.2 , we don't need any C compiler.
    I am trying to find, where is the external library, nothing under the function/..... subdirectory structure.

    regards

    Mujeeb

  7. #7
    Join Date
    May 2003
    Posts
    4

    Try

    I just had a similar problem...
    Ran a
    db2look -d <database> -e -o <outputfile> -p
    (enough to duplicate the database)...
    In there you will have the full body (SQL).

    Best regards -Ole

Posting Permissions

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