aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

PCB-00230: Indicator table size must not be less than its host variable

PCB-00230: Indicator table size must not be less than its host variable
Cause: An host variable table was used with an indicator table declared with a smaller dimension. For example: EXEC SQL BEGIN DECLARE SECTION END-EXEC. 01 EMP-NUM OCCURS 4 TIMES PIC S9(4) COMP. 01 EMP-NUM-IND OCCURS 2 TIMES PIC S9(4) COMP. EXEC SQL END DECLARE SECTION END-EXEC. ... SELECT ... INTO EMP-NUM:EMP-NUM-IND ...
Action: Increase the size of the indicator table.

请先 登录 后评论

1 个回答

小智
PCB-00230:指示器表的大小不得小于其主变量,
.原因:主变量表与使用较小维度声明的指标表一起使用。例如:EXEC SQL BEGIN DECLARE SECTION END EXEC。01 EMP-NUM OCCURS 4 TIMES PIC S9(4)COMP。01 EMP-NUM-IND OCCURS 2 TIMES PIC S9(4)COMP。EXEC SQL END DECLARE SECTION END-EXEC。... SELECT ... INTO EMP-NUM:EMP-NUM-IND ...,
.操作:增加指标表的大小。,
.
请先 登录 后评论