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

2019-08-30 19:46

Explanation: View or logical file &1 in &2 read-only.

SQL0151 SQLCODE -151 SQLSTATE 42808

Explanation: Column &1 in table &2 in &3 read-only.

SQL0152 SQLCODE -152 SQLSTATE 42809

Explanation: Constraint type not valid for constraint &1 in &2.

SQL0153 SQLCODE -153 SQLSTATE 42908

Explanation: Column list required for CREATE VIEW.

SQL0154 SQLCODE -154 SQLSTATE 42909

Explanation: UNION and UNION ALL for CREATE VIEW not valid.

SQL0156 SQLCODE -156 SQLSTATE 42809

Explanation: &1 in &2 not a table.

SQL0157 SQLCODE -157 SQLSTATE 42810

Explanation: View &1 in &2 not valid in FOREIGN KEY clause.

SQL0158 SQLCODE -158 SQLSTATE 42811

Explanation: Number of columns specified not consistent.

SQL0159 SQLCODE -159 SQLSTATE 42809

Explanation: &1 in &2 not correct type.

SQL0160 SQLCODE -160 SQLSTATE 42813

Explanation: WITH CHECK OPTION not allowed for view &1 in &2.

SQL0161 SQLCODE -161 SQLSTATE 44000

Explanation: INSERT/UPDATE not allowed due to WITH CHECK OPTION.

SQL0170 SQLCODE -170 SQLSTATE 42605

Explanation: Number of arguments for function &1 not valid.

SQL0171 SQLCODE -171 SQLSTATE 42815

Explanation: Argument &1 of function &2 not valid.

SQL0175 SQLCODE -175 SQLSTATE 58028

Explanation: COMMIT failed.

SQL0180 SQLCODE -180 SQLSTATE 22007

Explanation: Syntax of date, time, or timestamp value not valid.

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 expression not valid.

SQL0184 SQLCODE -184 SQLSTATE 42610

Explanation: Parameter marker not valid in expression.

SQL0187 SQLCODE -187 SQLSTATE 42816

Explanation: Use of labeled duration is not valid.

SQL0188 SQLCODE -188 SQLSTATE 22503, 28000, 2E000

Explanation: &1 is not a valid string representation of an authorization name or a relational database name.

SQL0189 SQLCODE -189 SQLSTATE 22522

Explanation: Coded Character Set Identifier &1 is not valid.

SQL0190 SQLCODE -190 SQLSTATE 42837

Explanation: Attributes of column &3 in &1 in &2 not compatible.

SQL0191 SQLCODE -191 SQLSTATE 22504

Explanation: MIXED data not properly formed.

SQL0192 SQLCODE -192 SQLSTATE 42937

Explanation: Argument of TRANSLATE function not valid.

SQL0194 SQLCODE -194 SQLSTATE 42848

Explanation: KEEP LOCKS not allowed.

SQL0195 SQLCODE -195 SQLSTATE 42814

Explanation: Last column of &1 in &2 cannot be dropped.

SQL0196 SQLCODE -196 SQLSTATE 42817

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

SQL0197 SQLCODE -197 SQLSTATE 42877

Explanation: Column &1 cannot be qualified.

SQL0198 SQLCODE -198 SQLSTATE 42617

Explanation: SQL statement empty or blank.

SQL0199 SQLCODE -199 SQLSTATE 42601

Explanation: Keyword &1 not expected. Valid tokens: &2.

SQL0203 SQLCODE -203 SQLSTATE 42702

Explanation: Column &1 is ambiguous.

SQL0204 SQLCODE -204 SQLSTATE 42704

Explanation: &1 in &2 type *&3 not found.

SQL0205 SQLCODE -205 SQLSTATE 42703

Explanation: Column &1 not in table &2.

SQL0206 SQLCODE -206 SQLSTATE 42703

Explanation: Column &1 not in specified tables.

SQL0208 SQLCODE -208 SQLSTATE 42707

Explanation: ORDER BY column &1 not in results table.

SQL0212 SQLCODE -212 SQLSTATE 42712

Explanation: Duplicate table designator &1 not valid.

SQL0214 SQLCODE -214 SQLSTATE 42822

Explanation: ORDER BY expression is not valid.

SQL0221 SQLCODE -221 SQLSTATE 42873

Explanation: Number of rows &2 not valid.

SQL0225 SQLCODE -225 SQLSTATE 42872

Explanation: FETCH not valid; cursor &1 not declared with SCROLL.

SQL0226 SQLCODE -226 SQLSTATE 24507

Explanation: Current row deleted or moved for cursor &1.

SQL0227 SQLCODE -227 SQLSTATE 24513

Explanation: FETCH not valid, cursor &1 in unknown position.

SQL0228 SQLCODE -228 SQLSTATE 42620

Explanation: FOR UPDATE OF clause not valid with SCROLL for cursor &1.

SQL0231 SQLCODE -231 SQLSTATE 22006

Explanation: Position of cursor &1 not valid for FETCH of current row.

SQL0250 SQLCODE -250 SQLSTATE 42718


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

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

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

马上注册会员

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