PCB-00553: FOR clause not allowed on this statement

PCB-00553: FOR clause not allowed on this statement
Cause: A FOR clause was used with a SELECT, LOB, or DEALLOCATE DESCRIPTOR statement. A FOR clause cannot be used with these statements. In the case of a SELECT statement, data returned from the last loop in the execution of the SELECT would overwrite data returned in a previous loop.
Action: Remove the FOR clause from the statement. Use a host language construct to iteratively execute the statement.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:48

本声明中不允许使用PCB-00553：FOR子句,
.原因： FOR子句与SELECT，LOB或DEALLOCATE DESCRIPTOR语句一起使用。FOR子句不能与这些语句一起使用。在SELECT语句的情况下，在执行SELECT时从最后一个循环返回的数据将覆盖上一循环中返回的数据。,
.操作：从语句中删除FOR子句。使用主机语言构造来迭代地执行语句。,
.

aiaiDBA

13718043309

010-86462881

PCB-00553: FOR clause not allowed on this statement

1 个回答

相似问题