PCB-00235: Table size mismatch in INTO/USING. Minimum is: number

PCB-00235: Table size mismatch in INTO/USING. Minimum is: number
Cause: The size of a table variable in an INTO/USING clause of a dynamic EXECUTE statement has been ARRAYLEN...EXECUTE'd while the other host variable has not and is not a table of dimension 1 or a plain non-table host variable. Example: 01 X PIC X(10) OCCURS 10. 01 Y PIC S9(4) COMP OCCURS 10. 01 Z PIC S9(4) COMP. ... EXEC SQL ARRAYLEN X (DIM) EXECUTE END-EXEC. ... EXEC SQL EXECUTE S1 USING :X, :Y END-EXEC. <-- error EXEC SQL EXECUTE S1 USING :X, :Z END-EXEC. <-- ok Please note that this error differs from 233 in that it is an ERROR not a WARNING.
Action: ARRAYLEN...EXECUTE all of the table variables in the INTO/USING clause or those host variables not ARRAYLEN...EXECUTEd need to be of dimension 1.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:48

PCB-00235：INTO / USING中的表格大小不匹配。最小值为：number,
.原因：动态EXECUTE语句的INTO / USING子句中的表变量的大小已经是ARRAYLEN ... EXECUTE'd，而另一个主变量没有并且不是维1的表或普通非表主机变量。示例：01 X PIC X（10）OCCURS 10. 01 Y PIC S9（4）COMP OCCURS 10. 01 Z PIC S9（4）COMP。... EXEC SQL ARRAYLEN X（DIM）EXECUTE END-EXEC。... EXEC SQL EXECUTE S1使用：X，：Y END-EXEC。< - 错误EXEC SQL EXECUTE S1使用：X，：Z END-EXEC。< - ok请注意，此错误与233不同，因为它是错误而不是警告。,
.操作： ARRAYLEN ... EXECUTE INTO / USING子句中的所有表变量，或者这些主变量不是ARRAYLEN ... EXECUTED需要为1。,
.

aiaiDBA

13718043309

010-86462881

PCB-00235: Table size mismatch in INTO/USING. Minimum is: number

1 个回答

相似问题