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

You cannot get Stored Procedure using db2look. I guess it is because SPs can be written in other languages beside SQL.

Andy

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

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

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

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

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