June (6) September (9) November (11) 1–30 For February (month 2)1–28 (Years other than leap years.) 1–29 (Leap years only.) For months: January (month 1) March (3) May (5) July (7) August (8) October (10) December (12) ...
June (6) September (9) November (11) 1–30 For February (month 2)1–28 (Years other than leap years.) 1–29 (Leap years only.) For months: January (month 1) March (3) May (5) July (7) August (8) October (10) December (12) ...
1、word 资料db2 的常见 sqlcode所表示负数的含义sql0007 sqlcode -07sqlstate 42601explanation: character &1 (hex &2) not valid in sql statement. sql0010 sqlcode -10sqlstate 42603explanation: string constant beginning &1 not delimited. sql0029 sqlcode -29sqlstate 42601explanation: into clause ...
操作数据库过程中,遇到许多问题,很多都与SQL CODE和SQL State相关,现在把一个完整的SQLCODE和SQLState错误信息和相关解释作以下说明,一来可以自己参考,对DB2错误自行找出原因 (声明:这是搜集网上的资料得来的,详细出处不记得了) sqlcode sqlstate 说明 000 00000 SQL语句成功完成 01xxx SQL语句成功完成,但是有警告 +...
SQL0181 SQLCODE -181SQLSTATE 22007 Explanation: Value in date, time, or timestamp string not valid. SQL0182 SQLCODE -182SQLSTATE 42816 Explanation: A date, time, or timestamp expression not valid. SQL0183 SQLCODE -183SQLSTATE 22008 Explanation: The result of a date or timestamp expression ...
SQL0181 SQLCODE -181 SQLSTATE 22007 Explanation: Value in date, time, or timestamp string not valid. SQL0182 SQLCODE -182 SQLSTATE 42816 Explanation: A date, time, or timestamp expression not valid. SQL0183 SQLCODE -183 SQLSTATE 22008 Explanation: The result of a date or timestamp ...
DB2数据库常见sqlcode及原因 000 | 00000 | SQL语句成功完成 01xxx | SQL语句成功完成,但是有警告 +012 | 01545 | 未限定的列名被解释为一个有相互关系的引用 +098 | 01568 | 动态SQL语句用分号结束 +100 | 02000 | 没有找到满足SQL语句的行 +110 | 01561 | 用DATA CAPTURE定义的表的更新操作不能发送...
SQL0114 SQLCODE -114 SQLSTATE 42961 SQL0114 SQLCODE -114 SQLSTATE 42961 Explanation: Relational database &1 not the same as current server &2. 说明:关系型数据库和1不是因为当前的服务器和2相同。 SQL0115 SQLCODE -115 SQLSTATE 42601 SQL0115 SQLCODE -115 SQLSTATE 42601 Explanation: Compariso...
DB2 SQLCODE 错误信息 DB2错误信息（按sqlcode排序） sqlcodesqlstate说明 00000000SQL语句成功完成 01xxxSQL语句成功完成，但是有警告 +01201545未限定的列名被解释为一个有相互关系的引用 +09801568动态SQL语句用分号结束 +10002000没有找到满足SQL语句的行 +11001561用DATACAPTURE定义的表的更新操作不能发送到原来的子...
+30100 01558分布式协议错误被检测到,提供原来的SQLCODE和SQLSTATE -007 42601 SQL语句中由非法字符 -010 42603字符串常量非正常终止;检查到有遗漏的引号标志 -029 42601需要INTO语句 -060 42815某特定数据类型的长度或者标量规范无效 -084 42612不能执行SQL语句,因为该语句对动态SQL无效或者对OS/390的DB2无效 -097...