I have a variable declaration inside a procedure which is not compiling in db2 9.5 :-
DECLARE VSTARTTIME TIMESTAMP DEFAULT CURRENT TIMESTAMP;
The procedure is a test procedure :-
DROP PROCEDURE ABC_1
@
CREATE PROCEDURE ABC_1
(
INOUT STARTTIME TIMESTAMP ,
INOUT ENDTIME TIMESTAMP ,
OUT DIFFTIME DECIMAL(15,10)
)
LANGUAGE SQL
...
somadritadas23
Last Activity: Sep 3 '10, 12:09 PM
Joined: Aug 31 '10
Location:
-
somadritadas23 started a topic How to declare timestamp variable with default as current timestamp not working.in DB2How to declare timestamp variable with default as current timestamp not working.
-
somadritadas23 started a topic How to view a CLOB Output parameter returned from a procedure in DB2 control Center?in DB2How to view a CLOB Output parameter returned from a procedure in DB2 control Center?
How to view a CLOB Output parameter returned from a procedure in DB2 control Center(DB2 9.5).I have a procedure ABC having an output parameter ORET of CLOB datatype.This is ideally a long sql query which is formed after various conditions.But when I call the procedure the output comes as "Parameter Name : ORET, Parameter Value : - ".So how to view this output?
No activity results to display