PCC-00056: FOR clause not allowed on SELECT statement at line number in file string.

PCC-00056: FOR clause not allowed on SELECT statement at line number in file string.
Cause: A FOR clause was used with a SELECT statement. This is not allowed as data returned from the last loop in the execution of the SELECT overwrites data returned in a previous loop.
Action: Remove the FOR clause from the SELECT statement and use a host- language construct to iteratively execute the SELECT statement.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

PCC-00056：文件字符串中行号上的SELECT语句不允许使用FOR子句。,
.原因： FOR语句与SELECT语句一起使用。这是不允许的，因为执行SELECT中的最后一个循环返回的数据会覆盖上一个循环中返回的数据。,
.操作：从SELECT语句中删除FOR子句，并使用主机语言结构迭代执行SELECT语句。,
.

aiaiDBA

13718043309

010-86462881

PCC-00056: FOR clause not allowed on SELECT statement at line number in file string.

1 个回答

相似问题