aiaiDBA

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

13718043309

010-86462881

PCB-00700: This statement can only be used with DYNAMIC=ANSI

PCB-00700: This statement can only be used with DYNAMIC=ANSI
Cause: One of the following statements was used without specifying DYNAMIC=ANSI:
o EXEC SQL ALLOCATE/DEALLOCATE/GET/SET DESCRIPTOR

o EXEC SQL DESCRIBE OUTPUT/INPUT ... USING ...

o EXEC SQL EXECUTE ... INTO ...

o EXEC SQL EXECUTE ... USING...

o EXEC SQL OPEN ... INTO ...

o EXEC SQL OPEN ... USING...

o SCROLL in DECLARE CURSOR

o EXEC SQL FETCH ... where is NEXT, PRIOR, FIRST, LAST, ABSOLUTE, or RELATIVE

Action: Specify DYNAMIC=ANSI or remove statement(s) like those above.

请先 登录 后评论

1 个回答

小智
PCB-00700:此语句只能与DYNAMIC = ANSI一起使用,
.原因:使用以下语句之一而不指定DYNAMIC = ANSI:,
.o EXEC SQL ALLOCATE / DEALLOCATE / GET / SET描述符,
.,
.o EXEC SQL DESCRIBE OUTPUT / INPUT ... USING ... <描述符名称>,
.,
.o EXEC SQL EXECUTE ... INTO ...,
.,
.o EXEC SQL EXECUTE ... USING ... <描述符名称>,
.,
.o EXEC SQL OPEN ... INTO ...,
.,
.o EXEC SQL OPEN ... USING ... <描述符名称>,
.,
.o DECLARE CURSOR中的SCROLL,
.,
.o EXEC SQL FETCH ...其中是NEXT,PRIOR,FIRST,LAST,ABSOLUTE或RELATIVE,
.,
.操作:指定DYNAMIC = ANSI或删除如上所述的语句。,
.
请先 登录 后评论