var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: db2look no procedure statement
The database is ver8 .
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
You cannot get Stored Procedure using db2look. I guess it is because SPs can be written in other languages beside SQL.
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
But it is showing the create function, function also calls the other external
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.
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.
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.
I just had a similar problem...
db2look -d <database> -e -o <outputfile> -p
(enough to duplicate the database)...
In there you will have the full body (SQL).
Best regards -Ole