嵌入SQL的错误,SQL0302N

bigapple2008

SQL0302N  The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use.  SQLSTATE=22003
是这个错误代码,在运行的时候发生的.大概意思是插入数据库的字段和数据库里定义的不符合,我找到了详细的错误解释:

1. bash-3.00$ db2 ? SQL0302N
   
2. 
   
3. 
   
4. SQL0302N The value of a host variable in the EXECUTE or OPEN
   
5.           statement is too large for its corresponding use.
   
6. 
   
7. Explanation:
   
8. 
   
9. The value of an input host variable was found to be too large for
   
10. its use in the SELECT, VALUES, or prepared statement.  One of the
    
11. following occurred:
    
12. 
    
13. o   The corresponding host variable or parameter marker used in
    
14.     the SQL statement is defined as string, but the input host
    
15.     variable contains a string that is too long.
    
16. 
    
17. o   The corresponding host variable or parameter marker used in
    
18.     the SQL statement is defined as numeric, but the input host
    
19.     variable contains a numeric value that is too large.
    
20. 
    
21. o   The terminating NUL character is missing from the C language
    
22.     NUL-terminated character string host variable.
    
23. 
    
24. o   Federated system users: in a pass-through session, a data
    
25.     source-specific restriction might have been violated.
    
26. 
    
27. 
    
28. 
    
29. This error occurs as a result of specifying either an incorrect
    
30. host variable or an incorrect SQLLEN value in an SQLDA on an
    
31. EXECUTE or OPEN statement.
    
32. 
    
33. The statement cannot be processed.
    
34. 
    
35. User Response:
    
36. 
    
37. Ensure that the input host variable value is the correct type and
    
38. length.  If the input host variables supply values to parameter
    
39. markers, match values with the implied data type and length of
    
40. the parameter marker.
    
41. 
    
42. Federated system users: for a pass-through session, determine
    
43. what data source is causing the error (see the problem
    
44. determination guide for procedures to follow to identify the
    
45. failing data source).  Examine the SQL dialect for that data
    
46. source to determine which specific restriction has been violated,
    
47. and adjust the failing statement as needed.
    
48. 
    
49. sqlcode :  -302
    
50. 
    
51. sqlstate :  22001, 22003
    

复制代码

但我仔细检查过那些字段了,应该是没有上述情况的啊.
有没有人碰到过这个问题,还有什么其他的情况会导致这样啊.我把set语句后面的字段一个一个排查过来,就是每次就set一个字段还是不行.

天龙帮主

在 EXECUTE 或 OPEN 语句中的主机变量值对于其相应的使用来说过大。
说明:
发现输入主机变量的值对于其在 SELECT、VALUES 或准备语句中的使用来说太大。发生下列其中一种情况：

SQL 语句中使用的相应主机变量或参数标识符被定义为字符串，但是输入主机变量包含的字符串太长。
SQL 语句中使用的相应主机变量或参数标识符被定义为数字，但是输入主机变量包含的数值太大。
C 语言以 NUL 终止的字符串主机变量中丢失终止字符 NUL。
联合系统用户：在传递（Pass-Through）会话中，可能已违反特定于数据源的限制。
由于在 EXECUTE 或 OPEN 语句上的 SQLDA 中指定了不正确的主机变量或不正确的 SQLLEN 值，所以发生此错误。

不能处理该语句。

用户响应:
确保输入主机变量值的类型和长度是正确的。如果输入主机变量向参数标识符提供值，则使这些值与参数标识符的隐含数据类型和长度相匹配。

联合系统用户：对于传递（Pass-Through）会话，确定哪一个数据源导致该错误（请参阅 Problem determination guide 以了解标识失败数据源所要遵循的过程）。检查该数据源的 SQL 对话以确定违反了哪个特定限制，并根据需要来调整限制。

希望对你有帮助吧

lichengx

去打补丁吧