接下来我们使用 GROUP BY 语句 将数据表按名字进行分组，并统计每个人有多少条记录：
UNSUCCESSFUL EXECUTION CAUSED BY A SYSTEM ERROR THAT DOES NOT PRECLUDE THE SUCCESSFUL EXECUTION OF SUBSEQUENT SQL STATEMENTS
值得庆幸的是，已经有人帮我们整理出一份关于 DB2 的错误代码大全啦，以后再遇到数据库报错，直接拎出...
If an abend occurred, notify the system programmer for analysis of the abend that caused this return code. Even if an abend occurred, an application program receiving this return code can retry and is not prohibited from executing further SQL statements. If the error occurred during a commit, ...
DDL : SQLCODE = -901 SQLSTATE = 58004 TOKENS = 2 Schema : HENRY.CUSTOMER Type : TABLE Error Msg : LOAD operation problem DDL : SQLCODE = -901 SQLSTATE = 58004 TOKENS = 3 Schema : HENRY.PRODUCT Type : TABLE Error Msg : LOAD operation problem ...
SQL0125 SQLCODE -125 SQLSTATE 42805 SQL0125 SQLCODE -125 SQLSTATE 42805 Explanation: ORDER BY column number &1 not valid. 说明:按列号和1无效订单。 SQL0128 SQLCODE -128 SQLSTATE 42601 SQL0128 SQLCODE -128 SQLSTATE 42601 Explanation: Use of NULL is not valid. 说明:NULL使用是无效的。
SQL0421 SQLCODE -421 SQLSTATE 42826 SQL0421 SQLCODE -421 SQLSTATE 42826 Explanation: Number of UNION operands not equal. 说明:UNION操作数不相等的数量。 SQL0423 SQLCODE -423 SQLSTATE 0F001 SQL0423 SQLCODE -423 SQLSTATE 0F001 Explanation: LOB locator &1 not valid. 说明:LOB定位器和1无效。
DB2 的数据提供程序利用 IBM SQLCAMESSAGE 存储过程,该存储过程用于返回详细的错误消息。 若要使用此功能,应将数据源配置为对主机 CCSID 使用 EBCDIC 值。 下表描述的 DB2 服务器错误可能会在您执行更正操作所必须采取的措施时发生。 展开表 SQLSTATESQLCODE消息说明 ...
DB2的常有SQLCODE所表示负数的含义 DB2的常有SQLCODE所表示负数的含义 DB2的常有SQLCODE所表示负数的含义 DB2的常有SQLCODE所表示负数的含义 SQL0007SQLCODE-07SQLSTATE42601 Explanation:Character1(HEX2)notvalidinSQLstatement. SQL0010SQLCODE-10SQLSTATE42603 Explanation:Stringconstantbeginning1notdelimited. SQL0029...
SQLCODE 901 SQLSTATE 58004 Explanation SQL system error SQL0904 SQLCODE 904 SQLSTATE 57011 Explanation Resource limit exceeded SQL0906 SQLCODE 906 SQLSTATE 24514 Explanation Operation not performed because of previous error SQL0907 SQLCODE 907 SQLSTATE 27000 Explanation Attempt to change same row twice ...