When executing a Procedure as a script in the Editor in Toad for DB2; if Procedure DDL has any comments below the body of the Procedure, all the comments Between the "Create or Replace Procedure" statement and the "Begin" statement will not be kept.
For example:
Executing as a script the following Procedure in the Editor:
CREATE OR REPLACE PROCEDURE DB2ADMIN.TEST5 ( )
--SPECIFIC SQL120824084432800
LANGUAGE SQL
NOT DETERMINISTIC
EXTERNAL ACTION
MODIFIES SQL DATA
CALLED ON NULL INPUT
INHERIT SPECIAL REGISTERS
OLD SAVEPOINT LEVEL
/*
This is a comment to see if this shows up in the Object Explorer
End of Line
*/
BEGIN
declare S integer;
set S=(select d from ident where a=1);
END;
Then going to the Object Explorer for Procedures, all the comments will not be included.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center