Toad World® Forums

SQL procedure generation problem


#1

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)


#2

Hi Adam,

Please check out your private messages section for my reply.

Thanks.

Regards,

Vladka