Hi again,
When I use COMMENTS in “List of Arguments”:
IN p_AK_PRODUKT_NAZWA Varchar(50), /* Nazwa Produktu /
IN p_AK_PRODUKT_SYMBOL Varchar(20) / Symbol Produktu */
TDM generates CREATE PROCEDURE as follows. It is correct.
CREATE PROCEDURE “DB2TEST”.“INS_TDP_IN” (
IN p_AK_PRODUKT_NAZWA Varchar(50), /* Nazwa Produktu /
IN p_AK_PRODUKT_SYMBOL Varchar(20) / Symbol Produktu */
)
SPECIFIC “DB2TEST.INS_TDP_IN”
MODIFIES SQL DATA
NOT DETERMINISTIC
LANGUAGE SQL
NO EXTERNAL ACTION
(…)
But, Drop statement which TDM generates looks like:
DROP PROCEDURE “DB2TEST”.“INS_TDP_IN” (Varchar(50), */)
/
It is incorrect.
Please Help,
Best regards,
Adam
FYI:
Toad Data Modeler:
- File Version: 3.3.7.22
- Licence Number: XXX-XXXXX
- Licence Type: Permanent
Remaining Days: n/a
Expires On: n/a
Model:
Database: Db2 v.9 (LUW)