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

2019-08-30 19:46

SQL0509 SQLCODE -509 SQLSTATE 42827

Explanation: Table &2 in &3 not same as table in cursor &1.

SQL0510 SQLCODE -510 SQLSTATE 42828

Explanation: Cursor &1 for file &2 is read-only.

SQL0511 SQLCODE -511 SQLSTATE 42829

Explanation: FOR UPDATE OF clause not valid.

SQL0513 SQLCODE -513 SQLSTATE 42924

Explanation: Alias &1 in &2 cannot reference another alias.

SQL0514 SQLCODE -514 SQLSTATE 26501

Explanation: Prepared statement &2 not found.

SQL0516 SQLCODE -516 SQLSTATE 26501

Explanation: Prepared statement &2 not found.

SQL0517 SQLCODE -517 SQLSTATE 07005

Explanation: Prepared statement &2 not SELECT statement.

SQL0518 SQLCODE -518 SQLSTATE 07003

Explanation: Prepared statement &1 not found.

SQL0519 SQLCODE -519 SQLSTATE 24506

Explanation: Prepared statement &2 in use.

SQL0520 SQLCODE -520 SQLSTATE 42828

Explanation: Cannot UPDATE or DELETE on cursor &1.

SQL0525 SQLCODE -525 SQLSTATE 51015

Explanation: Statement not valid on application server.

SQL0527 SQLCODE -527 SQLSTATE 42874

Explanation: ALWCPYDTA(*NO) specified but temporary result required for &1.

SQL0530 SQLCODE -530 SQLSTATE 23503

Explanation: Insert or UPDATE value not allowed by referential constraint.

SQL0531 SQLCODE -531 SQLSTATE 23001, 23504

Explanation: Update prevented by referential constraint.

SQL0532 SQLCODE -532 SQLSTATE 23001, 23504

Explanation: Delete prevented by referential constraint.

SQL0536 SQLCODE -536 SQLSTATE 42914

Explanation: Delete not allowed because table referenced in subquery can be affected.

SQL0537 SQLCODE -537 SQLSTATE 42709

Explanation: Duplicate column name in definition of key.

SQL0538 SQLCODE -538 SQLSTATE 42830

Explanation: Foreign key attributes do not match parent key.

SQL0539 SQLCODE -539 SQLSTATE 42888

Explanation: Table does not have primary key.

SQL0541 SQLCODE -541 SQLSTATE 42891

Explanation: Duplicate UNIQUE constraint already exists.

SQL0543 SQLCODE -543 SQLSTATE 23511

Explanation: Constraint &1 conflicts with SET NULL or SET DEFAULT rule.

SQL0544 SQLCODE -544 SQLSTATE 23512

Explanation: CHECK constraint &1 cannot be added.

SQL0545 SQLCODE -545 SQLSTATE 23513

Explanation: INSERT or UPDATE not allowed by CHECK constraint.

SQL0546 SQLCODE -546 SQLSTATE 42621

Explanation: CHECK condition of constraint &1 not valid.

SQL0551 SQLCODE -551 SQLSTATE 42501

Explanation: Not authorized to object &1 in &2 type *&3.

SQL0552 SQLCODE -552 SQLSTATE 42502

Explanation: Not authorized to &1.

SQL0557 SQLCODE -557 SQLSTATE 42852

Explanation: Privilege not valid for table or view &1 in &2.

SQL0573 SQLCODE -573 SQLSTATE 42890

Explanation: Table does not have matching parent key.

SQL0574 SQLCODE -574 SQLSTATE 42894

Explanation: Default value not valid.

SQL0577 SQLCODE -577 SQLSTATE 38002, 2F002

Explanation: Modifying SQL data not permitted.

SQL0578 SQLCODE -578 SQLSTATE 2F005

Explanation: RETURN statement not executed for SQL function &1 in &2.

SQL0579 SQLCODE -579 SQLSTATE 38004, 2F004

Explanation: Reading SQL data not permitted.

SQL0580 SQLCODE -580 SQLSTATE 42625

Explanation: At least one result in CASE expression must be not NULL.

SQL0581 SQLCODE -581 SQLSTATE 42804

Explanation: The results in a CASE expression are not compatible.

SQL0583 SQLCODE -583 SQLSTATE 42845

Explanation: Use of function &1 in &2 not valid.

SQL0585 SQLCODE -585 SQLSTATE 42732

Explanation: Library &1 is used incorrectly on the SET PATH statement

SQL0590 SQLCODE -590 SQLSTATE 42734

Explanation: Name &1 specified in &2 not unique.

SQL0601 SQLCODE -601 SQLSTATE 42710

Explanation: Object &1 in &2 type *&3 already exists.

SQL0602 SQLCODE -602 SQLSTATE 54008

Explanation: More than 120 columns specified for CREATE INDEX.

SQL0603 SQLCODE -603 SQLSTATE 23515

Explanation: Unique index cannot be created because of duplicate keys.

SQL0604 SQLCODE -604 SQLSTATE 42611

Explanation: Attributes of column not valid.

SQL0607 SQLCODE -607 SQLSTATE 42832

Explanation: Operation not allowed on system table &1 in &2.

SQL0612 SQLCODE -612 SQLSTATE 42711

Explanation: &1 is a duplicate column name.

SQL0613 SQLCODE -613 SQLSTATE 54008

Explanation: Primary or unique key constraint too long.


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

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

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

马上注册会员

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