aiaiDBA

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

13718043309

010-86462881

PCB-00211: VARYING not supported with PIC N or PIC G variable "string"

PCB-00211: VARYING not supported with PIC N or PIC G variable "string"
Cause: The keyword VARYING was used in a PIC N variable declaration.
Action: Remove the keyword VARYING from the variable declaration. If you want to declare a PIC N VARCHAR variable, specify the precompiler option VARCHAR=YES and declare the variable as an implicit VARCHAR group item as illustrated by the following example: EXEC SQL BEGIN DECLARE SECTION END-EXEC. ... 01 ENAME. 05 ENAME-LEN PIC S9(4) COMP. 05 ENAME-ARR PIC N(20). ... EXEC SQL END DECLARE SECTION END-EXEC.

请先 登录 后评论

1 个回答

小智
PCB-00211:不支持PIC N或PIC G变量“ string ”,
.原因:关键字VARYING在PIC N变量声明中使用。,
.操作:从变量声明中删除关键字VARYING。如果要声明一个PIC N VARCHAR变量,请指定预编译器选项VARCHAR = YES,并将变量声明为隐式VARCHAR组项,如以下示例所示:EXEC SQL BEGIN DECLARE SECTION END-EXEC。... 01 ENAME 05 ENAME-LEN PIC S9(4)COMP。05 ENAME-ARR PIC N(20)。... EXEC SQL END DECLARE SECTION END-EXEC。,
.
请先 登录 后评论