Hi,
I used db2look to generate a DDL file but for procedure give me this type
CREATE PROCEDURE "x "."ffddffd"
(
IN V_PCHARGEID INTEGER
)
DYNAMIC RESULT SETS 1
SPECIFIC SQL050222142447354
EXTERNAL NAME 'db2pvm!pvm_entry'
LANGUAGE SQL
PARAMETER STYLE GNRLNULL
NOT DETERMINISTIC
NOT FENCED NOT THREADSAFE
MODIFIES SQL DATA
NO DBINFO;
Why I don't have the code for the procedure?
I used this command
db2look -d database -i creator -e -o c:\myfile.sql
Did I forgot something?
Thanks
I used db2look to generate a DDL file but for procedure give me this type
CREATE PROCEDURE "x "."ffddffd"
(
IN V_PCHARGEID INTEGER
)
DYNAMIC RESULT SETS 1
SPECIFIC SQL050222142447354
EXTERNAL NAME 'db2pvm!pvm_entry'
LANGUAGE SQL
PARAMETER STYLE GNRLNULL
NOT DETERMINISTIC
NOT FENCED NOT THREADSAFE
MODIFIES SQL DATA
NO DBINFO;
Why I don't have the code for the procedure?
I used this command
db2look -d database -i creator -e -o c:\myfile.sql
Did I forgot something?
Thanks