February 25th, 2005, 04:13 PM
|
|
Registered User
|
|
Join Date: Jan 2005
Posts: 16
Time spent in forums: 39 m 27 sec
Reputation Power: 0
|
|
|
db2look
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
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
