DB2的常见SQLCODE所表示负数的含义(6)

2019-08-30 19:46

SQL0614 SQLCODE -614 SQLSTATE 54008

Explanation: Length of columns for CREATE INDEX too long.

SQL0615 SQLCODE -615 SQLSTATE 55006

Explanation: Object &1 in &2 type *&3 not dropped. It is in use.

SQL0616 SQLCODE -616 SQLSTATE 42893

Explanation: &1 in &2 type &3 cannot be dropped with RESTRICT.

SQL0624 SQLCODE -624 SQLSTATE 42889

Explanation: Table already has primary key.

SQL0628 SQLCODE -628 SQLSTATE 42613

Explanation: Clauses are mutually exclusive.

SQL0629 SQLCODE -629 SQLSTATE 42834

Explanation: SET NULL not allowed for referential constraint.

SQL0631 SQLCODE -631 SQLSTATE 54008

Explanation: Foreign key for referential constraint too long.

SQL0637 SQLCODE -637 SQLSTATE 42614

Explanation: Duplicate &1 keyword.

SQL0642 SQLCODE -642 SQLSTATE 54021

Explanation: Maximum number of constraints exceeded.

SQL0658 SQLCODE -658 SQLSTATE 42917

Explanation: Function cannot be dropped.

SQL0666 SQLCODE -666 SQLSTATE 57005

Explanation: Estimated query processing time exceeds limit.

SQL0667 SQLCODE -667 SQLSTATE 23520

Explanation: Foreign key does not match a value in the parent key.

SQL0675 SQLCODE -675 SQLSTATE 42892

Explanation: Specified delete rule not allowed with existing trigger.

SQL0679 SQLCODE -679 SQLSTATE 57006

Explanation: Object &1 in &2 type *&3 not created due to pending operation.

SQL0683 SQLCODE -683 SQLSTATE 42842

Explanation: FOR DATA or CCSID clause not valid for specified type.

SQL0707 SQLCODE -707 SQLSTATE 42939

Explanation: Name &1 in &2 not allowed for distinct type.

SQL0713 SQLCODE -713 SQLSTATE 42815

Explanation: Host variable for &2 is NULL.

SQL0724 SQLCODE -724 SQLSTATE 54038

Explanation: Too many cascaded trigger programs.

SQL0751 SQLCODE -751 SQLSTATE 42987

Explanation: SQL statement &1 not allowed in stored procedure or trigger.

SQL0752 SQLCODE -752 SQLSTATE 0A001

Explanation: Connection cannot be changed. Reason code is &1.

SQL0773 SQLCODE -773 SQLSTATE 20000

Explanation: Case not found for CASE statement.

SQL0774 SQLCODE -774 SQLSTATE 2D522

Explanation: Statement cannot be executed within a compound SQL statement.

SQL0775 SQLCODE -775 SQLSTATE 42910

Explanation: Statement not allowed in a compound SQL statement.

SQL0776 SQLCODE -776 SQLSTATE 428D4

Explanation: Cursor &1 specified in FOR statement not allowed.

SQL0777 SQLCODE -777 SQLSTATE 42919

Explanation: Nested compound statements not allowed.

SQL0778 SQLCODE -778 SQLSTATE 428D5

Explanation: End label &1 not same as begin label.

SQL0779 SQLCODE -779 SQLSTATE 42736

Explanation: Label &1 specified on LEAVE statement not valid.

SQL0780 SQLCODE -780 SQLSTATE 428D6

Explanation: UNDO specified for a handler and ATOMIC not specified.

SQL0781 SQLCODE -781 SQLSTATE 42737

Explanation: Condition &1 specified in handler not defined.

SQL0782 SQLCODE -782 SQLSTATE 428D7

Explanation: Condition value &1 specified in handler not valid.

SQL0783 SQLCODE -783 SQLSTATE 42738

Explanation: Select list for cursor &1 in FOR statement not valid.

SQL0784 SQLCODE -784 SQLSTATE 42860

Explanation: Check constraint &1 cannot be dropped.

SQL0785 SQLCODE -785 SQLSTATE 428D8

Explanation: Use of SQLCODE or SQLSTATE not valid.

SQL0802 SQLCODE -802 SQLSTATE 22003, 22012, 22023, 22504

Explanation: Data conversion or data mapping error.

SQL0803 SQLCODE -803 SQLSTATE 23505

Explanation: Duplicate key value specified.

SQL0804 SQLCODE -804 SQLSTATE 07002

Explanation: SQLDA not valid.

SQL0805 SQLCODE -805 SQLSTATE 51002

Explanation: SQL package &1 in &2 not found.

SQL0811 SQLCODE -811 SQLSTATE 21000

Explanation: Result of SELECT INTO or subquery more than one row.

SQL0818 SQLCODE -818 SQLSTATE 51003

Explanation: Consistency tokens do not match.

SQL0822 SQLCODE -822 SQLSTATE 51004

Explanation: Address in SQLDA not valid.

SQL0827 SQLCODE -827 SQLSTATE 42862

Explanation: &1 in &2 type *SQLPKG cannot be accessed.

SQL0840 SQLCODE -840 SQLSTATE 54004

Explanation: Number of selected items exceeds 8000.

SQL0842 SQLCODE -842 SQLSTATE 08002

Explanation: Connection already exists.

SQL0843 SQLCODE -843 SQLSTATE 08003

Explanation: Connection does not exist.


DB2的常见SQLCODE所表示负数的含义(6).doc 将本文的Word文档下载到电脑 下载失败或者文档不完整,请联系客服人员解决!

下一篇:2018高考高三生物模拟试题(六)及答案

相关阅读
本类排行
× 注册会员免费下载(下载后可以自由复制和排版)

马上注册会员

注:下载文档有可能“只有目录或者内容不全”等情况,请下载之前注意辨别,如果您已付费且无法下载或内容有问题,请联系我们协助你处理。
微信: QQ: