Interview Questions   Tutorials   Discussions   Programs   

DB2 - How to resolve SQL Code -310? The db table field is declared as Decimal(7,2)?




762
views
asked mar August 3, 2014 05:16 AM  

How to resolve SQL Code -310? The db table field is declared as Decimal(7,2)?


           

1 Answers



 
answered By Mswami   0  
SQL Code: -310
DECIMAL HOST VARIABLE OR PARAMETER number CONTAINS NON-DECIMAL DATA.

Explanation:
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).

number:
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).

System action:
The statement cannot be processed.

Programmer response:
Correct the application program or stored procedure. Ensure that all decimal variables or parameters contain valid System/370 packed decimal numbers.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert