NetCOBOL V11.0 メッセージ集

2.9.9 ODBC-8100E

入力文は不当です．

例題

[SP8100.cob]
000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8100.
000003 DATA           DIVISION.
000004 WORKING-STORAGE SECTION.
000005     EXEC SQL BEGIN DECLARE SECTION END-EXEC.
000006 01 STOCK-TABLE.
000007   02 PRDCTNUM   PIC S9(4) COMP-5.
000008   02 PRDCTNAM   PIC N(10).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 VAR-IND1     PIC S9(4) COMP-5.
000012     EXEC SQL END DECLARE SECTION END-EXEC.
000013 PROCEDURE DIVISION.
000014     EXEC SQL
000015       DECLARE C1 CURSOR FOR
000016         SELECT PNO FROM STOCK WHERE :PRDCTNAM = 'TIRE'
000017     END-EXEC
000018     EXEC SQL OPEN C1 END-EXEC.
000019     EXEC SQL FETCH C1 :PRDCTNUM END-EXEC.
000020     DISPLAY "Product NO." PRDCTNUM
000021     EXEC SQL CLOSE C1 END-EXEC.
000022     .

SP8100.cob 19: JMN2633I-S SQL文に誤りがあります．ODBC-8100E 入力文は不当です．

詳細な説明

該当する行のSQL文に以下の誤りが考えられます．

• FETCH文にINTO句の指定がない

• PREPARE文にFROM句の指定がない