review the steps You are using to provide the <numeric> value to the sql statement
use the dclgen command to find out the proper definition for the field You are using and convert the value accordingly
with the scarce info You have given us, the only suggestion is ...
fix Your program!
Hi Enrico, thanks for the quick reply. I am trying to implement your suggestion. While moving the data into the fields decimal or retrieving the data, can I use the fucntion DECIMAL so that the data is converted and retrieved?
-310 DECIMAL HOST VARIABLE OR PARAMETER number CONTAINS NON-DECIMAL DATA
DB2 received nondecimal data from either an application (in the form of a host variable), function or a stored procedure (in the form of a parameter that was passed to or from function or a stored procedure).
Identifies either the host variable number (if the message is issued as a result of a FETCH, INSERT, UPDATE, MERGE, DELETE, SELECT, VALUES INTO, or SET assignment statement), or the parameter number (if the message is issued as the result of the invocation of a function, or a CALL statement).
The statement cannot be processed.
Correct the application program or stored procedure. Ensure that all decimal variables or parameters contain valid System/370 packed decimal numbers.
IIRC the DECIMAL function is used to retrieve/fetch data ...
from the post looks more like the value in the host variable is not in the proper format ( packed )