Yoyoyo
New User
Joined: 19 Sep 2006 Posts: 26
|
|
|
|
Hey Chaitra,
Hope this will be helpful....
-310: DECIMAL HOST VARIABLE OR PARAMETER number CONTAINS NON-DECIMAL DATA SQLSTATE: 22023
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, 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).
you need to correct the application program or stored procedure. Ensure that all decimal variables or parameters contain valid System/370
packed decimal numbers.
Take care!!
YoYoYo |
|