views:

14

answers:

1

Want to enter negative values in input parameter in Db2 stored procedure, but it is not accepting negative values..

Please help..

A: 

Use signed type or use other boolean variable to interpret a negative sign and type your value in unsigned formation.

Svisstack
in CREATE PROCEDURE sysproc.SPNAME ( IN --- which data type i need to give so that it should accept negative valuess.. )
jitendra
In DB2 Development centre -- SP is not accepting negative values...I want to enter -243.55 but it is not accepting negative value when i enter...
jitendra
not getting...if you can please elaborate it...
jitendra