Top
NetCOBOL V11.0 Messages
FUJITSU Software

2.2.8 ODBC

2244

7600

8004

8005

8008

8009

8016

8052

8100

8112

8116

8308

8309

8310

8323

8325

8326

8327

8328E

8329

8340

8356

8386

8408

8409

8410

8430

8431

8432

8433

8434

8435

8476

8477

8478

8486

8499

8503

8601

8718

8725

8766

8772

8773

8956

8957

8992

8994

ODBC-2244E

Invalid data type of indicator variable.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP2244.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 VAR-IND1     PIC S9(9) COMP-5.
000012 01 VAR-IND2     PIC S9(4) COMP-3.
000013     EXEC SQL END DECLARE SECTION END-EXEC.
000014 PROCEDURE DIVISION.
000015     EXEC SQL
000016       CALL SPROCEDRE.SELECT1(:PRDCTNUM:VAR-IND1)
000017     END-EXEC
000018     EXEC SQL
000019       CALL SPROCEDRE.SELECT2(:PRDCTNAM:VAR-IND2)
000020     END-EXEC
000021    .

SP2244.cob (16) : JMN2633I-S The SQL statement is invalid. ODBC-2244E Invalid data type of indicator variable.

SP2244.cob (19) : JMN2633I-S The SQL statement is invalid. ODBC-2244E Invalid data type of indicator variable.

Explanation

Define the indicator variable using 4 digit signed binary integer data items.

ODBC-7600E

Not executable SQL statement.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP7600.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 VAR-IND      PIC S9(4) COMP-5.
000012     EXEC SQL END DECLARE SECTION END-EXEC.
000013 PROCEDURE DIVISION.
000014     EXEC SQL
000015       CREATE TABLE STOCK (PRDCT-NO INTEGER, PRDCT-NM CHAR(20))
000016     END-EXEC
000017     EXEC SQL
000018       ALLOCATE DESCRIPTOR SQLDA1 WITH MAX 25
000019     END-EXEC
000020    .

SP7600.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-7600E Not executable SQL statement.

SP7600.cob (18) : JMN2633I-S The SQL statement is invalid. ODBC-7600E Not executable SQL statement.

Explanation

A SQL statement was encountered that cannot be executed by this compiler.

ODBC-8004E

Right parenthesis corresponding to left parenthesis is missing near "@1@".

Parameter Explanation

@1@: stored procedure name

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8004.
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 X(20).
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       CALL SPROCEDRE.SELECT1(
000016     END-EXEC
000017     EXEC SQL
000018       CALL SPROCEDRE.SELECT2(:PRDCTNUM:VAR-IND1
000019     END-EXEC
000020     .

SP8004.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8004E Right parenthesis corresponding to left parenthesis is missing near "SPROCEDRE.SELECT1".

SP8004.cob (18) : JMN2633I-S The SQL statement is invalid. ODBC-8004E Right parenthesis corresponding to left parenthesis is missing near "SPROCEDRE.SELECT2".

Explanation

The right parentheses are missing from the CALL statements. Verify that each left parenthesis has a corresponding right parenthesis.

ODBC-8005E

Format of national character literal is invalid.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8005.
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       SELECT PRDCT-NO FROM STOCK WHERE PRDCT-NM = N'ABC'
000016     END-EXEC
000017     .

SP8005.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8005E Format of national character literal is invalid.

Explanation

There is an error in the description of the national character string literal. Refer to "National Character String Literal" in Chapter 8 of the "NetCOBOL Language Reference".

ODBC-8008E

Format of embedded variables name is invalid.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8008.
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       SELECT PRDCT-NO FROM STOCK WHERE :PRDCTNAM(1:4) = 'TIRE '
000016     END-EXEC
000017     .

SP8008.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8008E Format of embedded variables name is invalid.

Explanation

A host variable cannot be reference modified or subscripted in a SQL statement.

ODBC-8009E

Format of nonnumeric literal is invalid.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8009.
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       SELECT PRDCT-NO FROM STOCK WHERE :PRDCTNAM = ''
000016     END-EXEC
000017     .

SP8009.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8009E Format of nonnumeric literal is invalid.

Explanation

The character string literal must contain a character string.

ODBC-8016E

C language comment cannot be specified.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8016.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 VAR-IND      PIC S9(4) COMP-5.
000012     EXEC SQL END DECLARE SECTION END-EXEC.
000013 PROCEDURE DIVISION.
000014     EXEC SQL
000015       /* COMMENT */
000016       CALL SPROCEDRE.SELECT1(:PRDCTNUM:VAR-IND)
000017     END-EXEC
000018    .

SP8016.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8016E C language comment cannot be specified.

Explanation

C language comment indicators "/*"and "*/" cannot be used in SQL statements. Use "*" or (--) to indicate comments in SQL statements. Refer to "Token" in Chapter 8 of the "NetCOBOL Language Reference".

ODBC-8052E

Format of delimited identifier "@1@" is invalid.

Parameter Explanation

@1@: delimiting identifier

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8052.
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       SELECT "" FROM STOCK WHERE :PRDCTNAM = 'TIRE'
000016     END-EXEC
000017     .

SP8052.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8052E Format of delimited identifier "" is invalid.

Explanation

The delimiting identifier must contain a character string.

ODBC-8100E

SQL statement is invalid.

Example

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 The SQL statement is invalid. ODBC-8100E SQL statement is invalid.

Explanation

Errors that can cause this message to be output include:

  • An INTO clause is not specified for the FETCH statement (as shown in the example above).

  • A FROM clause is not specified for the PREPARE statement.

ODBC-8112E

Format of host variable specification is invalid.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8112.
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 01 SQLSTMT      PIC X(500).
000013     EXEC SQL END DECLARE SECTION END-EXEC.
000014 PROCEDURE DIVISION.
000015     MOVE "SELECT PNO FROM STOCK WHERE PNAME = ?" TO SQLSTMT
000016     EXEC SQL PREPARE STM1 FROM :SQLSTMT END-EXEC
000017     EXEC SQL EXECUTE STM1 USING 'TIRE' END-EXEC
000018     .

SP8112.cob (17) : JMN2633I-S The SQL statement is invalid. ODBC-8112E Format of host variable specification is invalid.

Explanation

Host variables must be specified for the USING clause.

ODBC-8116E

Format of argument list is invalid.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8116.
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 X(20).
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       CALL SPROCEDRE.SELECT1(PRDCTNUM)
000016     END-EXEC
000017     EXEC SQL
000018       CALL SPROCEDRE.SELECT2(:PRDCTNUM,)
000019     END-EXEC
000020     .

SP8116.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8116E Format of argument list is invalid.

SP8116.cob (18) : JMN2633I-S The SQL statement is invalid. ODBC-8116E Format of argument list is invalid.

Explanation

Errors that can cause this message to be output include:

  • The arguments of the CALL statement are not host variables or literals (as shown in the example above).

  • The argument list of the CALL statement ends with a separator.

ODBC-8308E

Cursor name is missing near "@1@".

Parameter Explanation

@1@: DECLARE

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8308.
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 CURSOR C1 FOR
000016         SELECT PNO FROM STOCK WHERE :PRDCTNAM = 'TIRE'
000017     END-EXEC
000018     .

SP8308.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8308E Cursor name is missing near "DECLARE".

Explanation

Errors that can cause this message to be output include:

  • The cursor name is not specified immediately following DECLARE in DECLARE CURSOR (as shown in the example above).

  • The cursor name is not specified for CURRENT OF.

ODBC-8309E

SQL statement identifier name is missing near "@1@".

Parameter Explanation

@1@: EXECUTE

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8309.
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 01 SQLSTMT      PIC X(500).
000013     EXEC SQL END DECLARE SECTION END-EXEC.
000014 PROCEDURE DIVISION.
000015     MOVE "SELECT PNO FROM STOCK WHERE PNAME = ?" TO SQLSTMT
000016     EXEC SQL PREPARE STM1 FROM :SQLSTMT END-EXEC
000017     EXEC SQL EXECUTE USING :PRDCTNAM END-EXEC
000018     .

SP8309.cob (17) : JMN2633I-S The SQL statement is invalid. ODBC-8309E SQL statement identifier name is missing near "EXECUTE".

Explanation

A SQL statement identifier must be specified immediately following the EXECUTE.

ODBC-8310E

Stored procedure name is missing near "@1@".

Parameter Explanation

@1@: CALL

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8310.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 VAR-IND      PIC S9(4) COMP-5.
000012     EXEC SQL END DECLARE SECTION END-EXEC.
000013 PROCEDURE DIVISION.
000014     EXEC SQL
000015       CALL (:PRDCTNUM:VAR-IND)
000016     END-EXEC
000017    .

SP8310.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8310E Stored procedure name is missing near "CALL".

Explanation

The stored procedure name must be specified immediately following the CALL.

ODBC-8323E

Left parenthesis is missing near "@1@".

Parameter Explanation

@1@: stored procedure name

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8323.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 VAR-IND      PIC S9(4) COMP-5.
000012     EXEC SQL END DECLARE SECTION END-EXEC.
000013 PROCEDURE DIVISION.
000014     EXEC SQL
000015       CALL SELECT1 :PRDCTNUM:VAR-IND)
000016     END-EXEC
000017    .

SP8323.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8323E Left parenthesis is missing near "SELECT1".

Explanation

In the example above, the left parenthesis is missing from the CALL SELECT1 argument. Verify that each right parenthesis has a corresponding left parenthesis.

ODBC-8325E

Connect target is missing near "@1@".

Parameter Explanation

@1@: CONNECT, TO

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8325.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 VAR-IND      PIC S9(4) COMP-5.
000012     EXEC SQL END DECLARE SECTION END-EXEC.
000013 PROCEDURE DIVISION.
000014     EXEC SQL CONNECT DEFAULT END-EXEC
000015     EXEC SQL CONNECT TO END-EXEC
000016     EXEC SQL CALL SELECT1(:PRDCTNUM) END-EXEC
000017    .

SP8325.cob (14) : JMN2633I-S The SQL statement is invalid. ODBC-8325E Connect target is missing near "CONNECT".

SP8325.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8325E Connect target is missing near "TO".

Explanation

Errors that can cause this message to be output include:

  • The CONNECT statement does not have a TO specification (as shown in the example above).

  • A connection target is not specified for TO.

ODBC-8326E

Connect object is missing near "@1@".

Parameter Explanation

@1@: SET CONNECTION

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8326.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 SQLCON       PIC X(30).
000012 01 VAR-IND      PIC S9(4) COMP-5.
000013     EXEC SQL END DECLARE SECTION END-EXEC.
000014 PROCEDURE DIVISION.
000015     EXEC SQL SET CONNECTION END-EXEC
000016     EXEC SQL CALL SELECT1(:PRDCTNUM) END-EXEC
000017    .

SP8326.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8326E Connect object is missing near "SET CONNECTION".

Explanation

A connection object must be specified for the SET CONNECTION statement.

ODBC-8327E

Disconnect object is missing near "@1@".

Parameter Explanation

@1@: DISCONNECT

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8327.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 VAR-IND      PIC S9(4) COMP-5.
000012     EXEC SQL END DECLARE SECTION END-EXEC.
000013 PROCEDURE DIVISION.
000014     EXEC SQL CONNECT TO DEFAULT END-EXEC
000015     EXEC SQL CALL SELECT1(:PRDCTNUM) END-EXEC
000016     EXEC SQL DISCONNECT END-EXEC
000017    .

SP8327.cob (16) : JMN2633I-S The SQL statement is invalid. ODBC-8327E Disconnect object is missing near "DISCONNECT".

Explanation

A disconnection object must be specified for the DISCONNECT statement.

ODBC-8328E

Connection name is missing near "@1@".

Parameter Explanation

@1@: AS

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8328.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 SQLCON       PIC X(30).
000012 01 VAR-IND      PIC S9(4) COMP-5.
000013     EXEC SQL END DECLARE SECTION END-EXEC.
000014 PROCEDURE DIVISION.
000015     EXEC SQL CONNECT TO :SQLCON AS END-EXEC
000016     EXEC SQL CALL SELECT1(:PRDCTNUM) END-EXEC
000017    .

SP8328.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8328E Connection name is missing near "AS".

Explanation

The connection name must be specified for AS of the CONNECT statement.

ODBC-8329E

Username is missing near "@1@".

Parameter Explanation

@1@: USER

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8329.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 SQLCON       PIC X(30).
000012 01 VAR-IND      PIC S9(4) COMP-5.
000013     EXEC SQL END DECLARE SECTION END-EXEC.
000014 PROCEDURE DIVISION.
000015     EXEC SQL CONNECT TO :SQLCON USER END-EXEC
000016     EXEC SQL CALL SELECT1(:PRDCTNUM) END-EXEC
000017    .

SP8329.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8329E Username is missing near "USER".

Explanation

A username must be specified for USER of the CONNECT statement.

ODBC-8340E

Target specification is missing near "@1@".

Parameter Explanation

@1@: clause

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8340.
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 INTO END-EXEC.
000020     DISPLAY "Product NO." PRDCTNUM
000021     EXEC SQL CLOSE C1 END-EXEC.
000022     .

SP8340.cob (19) : JMN2633I-S The SQL statement is invalid. ODBC-8340E Target specification is missing near "INTO".

Explanation

The target specification must be specified for the clause output to the message.

ODBC-8356E

Query expression or SQL statement identifier is missing.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8356.
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     END-EXEC
000017     .

SP8356.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8356E Query expression or SQL statement identifier is missing.

Explanation

Errors that can cause this message to be output include:

  • A query expression is not specified for the cursor of the Declare Cursor (as shown in the example above).

  • A SQL statement identifier is not specified for the Dynamic Declare Cursor.

ODBC-8386E

SQL statement variable is missing near "@1@".

Parameter Explanation

@1@: FROM, IMMEDIATE

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8386.
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 01 SQLSTMT      PIC X(500).
000013     EXEC SQL END DECLARE SECTION END-EXEC.
000014 PROCEDURE DIVISION.
000015     MOVE "SELECT PNO FROM STOCK WHERE PNAME = ?" TO SQLSTMT
000016     EXEC SQL PREPARE STM1 FROM SQLSTMT END-EXEC
000017     EXEC SQL EXECUTE IMMEDIATE STM1 USING :PRDCTNAM END-EXEC
000018     .

SP8386.cob (16) : JMN2633I-S The SQL statement is invalid. ODBC-8386E SQL statement variable is missing near "FROM".

SP8386.cob (17) : JMN2633I-S The SQL statement is invalid. ODBC-8386E SQL statement variable is missing near "IMMEDIATE".

Explanation

Errors that can cause this message to be output include:

  • The SQL statement variables specified for FROM of the PREPARE statement are not Host variables.

  • The SQL statement variables specified for the EXECUTE IMMEDIATE statement are not Host variables.

ODBC-8408E

Invalid specification after cursor name "@1@".

Parameter Explanation

@1@: cursor name

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8408.
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 INTO :PRDCTNUM END-EXEC.
000020     DISPLAY "Product NO." PRDCTNUM
000021     EXEC SQL CLOSE C1 RELEASE END-EXEC.
000022     .

SP8408.cob (21) : JMN2633I-S The SQL statement is invalid. ODBC-8408E Invalid specification after cursor name "C1".

Explanation

There is an invalid word following the cursor name of the CLOSE statement.

ODBC-8409E

Invalid specification after SQL statement identifier "@1@".

Parameter Explanation

@1@: SQL statement identifier

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8409.
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 SQLSTMT      PIC X(128).
000012 01 VAR-IND1     PIC S9(4) COMP-5.
000013     EXEC SQL END DECLARE SECTION END-EXEC.
000014 PROCEDURE DIVISION.
000015     MOVE "SELECT PNO FROM STOCK WHERE PNAME = ?" TO SQLSTMT
000016     EXEC SQL PREPARE STM1 FROM :SQLSTMT END-EXEC
000017     EXEC SQL DECLARE C1 CURSOR FOR STM1 FROM END-EXEC
000018     .

SP8409.cob (17) : JMN2633I-S The SQL statement is invalid. ODBC-8409E Invalid specification after SQL statement identifier "STM1".

Explanation

Errors that can cause this message to be output include:

  • There is an invalid word immediately following the SQL statement identifier of the Dynamic Declare Cursor.

  • There is an invalid word immediately following the SQL statement identifier of the EXECUTE statement.

ODBC-8410E

Invalid specification after argument list.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8410.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 VAR-IND      PIC S9(4) COMP-5.
000012 01 RTCD         PIC S9(4) COMP-5.
000013     EXEC SQL END DECLARE SECTION END-EXEC.
000014 PROCEDURE DIVISION.
000015     EXEC SQL
000016       CALL SELECT1(:PRDCTNUM:VAR-IND) RETURNING RTCD
000017     END-EXEC
000018    .

SP8410.cob (16) : JMN2633I-S The SQL statement is invalid. ODBC-8410E Invalid specification after argument list.

Explanation

There is an invalid word immediately following the right parenthesis of the argument list of the CALL statement.

ODBC-8430E

FOR phrase can not specify in "@1@" statement.

Parameter Explanation

@1@: SQL statement

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8430.
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 OCCURS 3.
000008   02 PRDCTNAM PIC N(10)        OCCURS 3.
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 01 CNT          PIC S9(4) COMP-5.
000014 PROCEDURE DIVISION.
000015     EXEC SQL
000016       DECLARE C1 CURSOR FOR
000017         SELECT PNO FROM STOCK WHERE PRDCTNAM = 'TIRE'
000018     END-EXEC
000019     EXEC SQL OPEN C1 END-EXEC
000020     EXEC SQL FOR 3 CALL PROC.FETCH1 END-EXEC
000021     EXEC SQL CLOSE C1 END-EXEC
000022     .

SP8430.cob (20) : JMN2633I-S The SQL statement is invalid. ODBC-8430E FOR phrase can not specify in "CALL" statement.

Explanation

The FOR clause can be used only in conjunction with the following SQL statements that specify the host variable with multiple rows specified or the host variable with a table specified:

  • SELECT

  • INSERT

  • FETCH (searched)

  • UPDATE (searched)

  • DELETE

  • EXECUTE

ODBC-8431E

Invalid specification of SQL statement variable in "@1@" statement.

Parameter Explanation

@1@: SQL statement

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8431.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 VAR-IND      PIC S9(4) COMP-5.
000012     EXEC SQL END DECLARE SECTION END-EXEC.
000013 PROCEDURE DIVISION.
000014     EXEC SQL CONNECT TO DEFAULT END-EXEC
000015     EXEC SQL CALL SELECT1(:STOCK-TABLE) END-EXEC
000016    .

SP8431.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8431E Invalid specification of SQL statement variable in "CALL" statement.

Explanation

Host variables other than the Host variables of a single column specified are specified to the places where only the ones of a single column specified are allowed for the Host variable specification.

ODBC-8432E

Invalid specification position or method of FOR phrase.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8432.
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 :PRDCTNUM = 1
000017     END-EXEC
000018     EXEC SQL OPEN C1 END-EXEC.
000019     EXEC SQL FOR 3 FETCH C1 INTO :PRDCTNUM END-EXEC.
000020     DISPLAY "Product NO." PRDCTNUM
000021     EXEC SQL CLOSE C1 END-EXEC.
000022     .

SP8432.cob (19) : JMN2633I-S The SQL statement is invalid. ODBC-8432E Invalid specification position or method of FOR phrase.

Explanation

Errors that can cause this message to be output are as follows:

  • Error in the location of the FOR phrase in the statement.

  • Error in the format of the host variables (single column specified) of the statement specified for the FOR clause.

ODBC-8433E

Value in FOR phrase exceed its value in OCCURS clause.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8433.
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 OCCURS 3.
000008   02 PRDCTNAM PIC N(10)        OCCURS 3.
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 01 CNT          PIC S9(4) COMP-5.
000014 PROCEDURE DIVISION.
000015     EXEC SQL
000016       DECLARE C1 CURSOR FOR
000017         SELECT PNO FROM STOCK WHERE PRDCTNAM = 'TIRE'
000018     END-EXEC
000019     EXEC SQL OPEN C1 END-EXEC
000020     EXEC SQL FOR 4 FETCH C1 INTO :PRDCTNUM END-EXEC
000021     EXEC SQL CLOSE C1 END-EXEC
000022     .

SP8433.cob (20) : JMN2633I-S The SQL statement is invalid. ODBC-8433E Value in FOR phrase exceed its value in OCCURS clause.

Explanation

The number specified in the FOR phrase must be less than the number of iterations specified in the OCCURS clause.

ODBC-8434E

Form of host variable is different.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8433.
000003 DATA           DIVISION.
000004 WORKING-STORAGE SECTION.
000005     EXEC SQL BEGIN DECLARE SECTION END-EXEC.
000006 01 STOCK-TABLE1.
000007   02 PRDCTNUM PIC S9(4) COMP-5 OCCURS 3.
000008 01 STOCK-TABLE2.
000009   02 PRDCTNAM PIC N(10).
000010 01 SQLSTATE     PIC X(5).
000011 01 SQLMSG       PIC X(128).
000012 01 VAR-IND1     PIC S9(4) COMP-5.
000013     EXEC SQL END DECLARE SECTION END-EXEC.
000014 01 CNT          PIC S9(4) COMP-5.
000015 PROCEDURE DIVISION.
000016     EXEC SQL
000017         SELECT PNO, PNAME INTO :STOCK-TABLE1, :STOCK-TABLE2
000018         FROM STOCK WHERE PRDCTNAM = 'TIRE'
000019     END-EXEC
000020     .

SP8434.cob (17) : JMN2633I-S The SQL statement is invalid. ODBC-8434E Form of host variable is different.

Explanation

All host variables in the SQL statements must have the same format.

ODBC-8435E

Invalid form of indicator variable correspondence to host variable.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8435.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 VAR-IND      PIC S9(4) COMP-5.
000012     EXEC SQL END DECLARE SECTION END-EXEC.
000013 PROCEDURE DIVISION.
000014     EXEC SQL
000015       CALL SPROCEDRE.SELECT1(:STOCK-TABLE:VAR-IND)
000016     END-EXEC
000017    .

SP8435.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8435E Invalid form of indicator variable correspondence to host variable.

Explanation

The indicator variables and the host variables must have the same format.

ODBC-8476E

Invalid specification "@1@" after connect target.

Parameter Explanation

@1@: word

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8476.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 VAR-IND      PIC S9(4) COMP-5.
000012     EXEC SQL END DECLARE SECTION END-EXEC.
000013 PROCEDURE DIVISION.
000014     EXEC SQL CONNECT TO DEFAULT AS END-EXEC
000015     EXEC SQL CALL SELECT1(:PRDCTNUM) END-EXEC
000016    .

SP8476.cob (14) : JMN2633I-S The SQL statement is invalid. ODBC-8476E Invalid specification "AS" after connect target.

Explanation

There is an invalid word immediately following the DEFAULT specification of the CONNECT statement.

ODBC-8477E

Invalid specification "@1@" after connect object.

Parameter Explanation

@1@: word

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8477.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 VAR-IND      PIC S9(4) COMP-5.
000012     EXEC SQL END DECLARE SECTION END-EXEC.
000013 PROCEDURE DIVISION.
000014     EXEC SQL SET CONNECTION DEFAULT FROM STM1 END-EXEC
000015    .

SP8477.cob (14) : JMN2633I-S The SQL statement is invalid. ODBC-8477E Invalid specification "FROM" after connect object.

Explanation

There is an invalid word immediately following the connection object of the SET CONNECTION statement.

ODBC-8478E

Invalid specification "@1@" after disconnect object.

Parameter Explanation

@1@: word

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8478.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLCON       PIC X(30).
000011 01 SQLMSG       PIC X(128).
000012 01 VAR-IND      PIC S9(4) COMP-5.
000013     EXEC SQL END DECLARE SECTION END-EXEC.
000014 PROCEDURE DIVISION.
000015     EXEC SQL CONNECT TO :SQLCON END-EXEC
000016     EXEC SQL CALL SELECT1(:PRDCTNUM) END-EXEC
000017     EXEC SQL DISCONNECT :SQLCON RELEASE END-EXEC
000018    .

SP8478.cob (17) : JMN2633I-S The SQL statement is invalid. ODBC-8478E Invalid specification "RELEASE" after disconnect object.

Explanation

There is an invalid word immediately following the disconnection object of the DISCONNECT statement.

ODBC-8486E

Invalid specification after SQL statement variable.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8486.
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 01 SQLSTMT      PIC X(500).
000013     EXEC SQL END DECLARE SECTION END-EXEC.
000014 PROCEDURE DIVISION.
000015     MOVE "SELECT PNO FROM STOCK WHERE PNAME = ?" TO SQLSTMT
000016     EXEC SQL PREPARE STM1 FROM :SQLSTMT ALL END-EXEC
000017     EXEC SQL EXECUTE IMMEDIATE :SQLSTMT USING :PRDCTNAM END-EXEC
000018     .

SP8486.cob (16) : JMN2633I-S The SQL statement is invalid. ODBC-8486E Invalid specification after SQL statement variable.

SP8486.cob (17) : JMN2633I-S The SQL statement is invalid. ODBC-8486E Invalid specification after SQL statement variable.

Explanation

Errors that cause this message to be output in the example above include:

  • An invalid word immediately follows the SQL statement variables of the PREPARE statement.

  • An invalid word immediately follows the SQL statement variables of the EXECUTE IMMEDIATE statement.

ODBC-8499E

Invalid specification after keyword "@1@".

Parameter Explanation

@1@: COMMIT, ROLLBACK

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8499.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 VAR-IND      PIC S9(4) COMP-5.
000012     EXEC SQL END DECLARE SECTION END-EXEC.
000013 PROCEDURE DIVISION.
000014     EXEC SQL COMMIT IMMEDIATE END-EXEC
000015     EXEC SQL ROLLBACK RELEASE END-EXEC
000016    .

SP8499.cob (14) : JMN2633I-S The SQL statement is invalid. ODBC-8499E Invalid specification after keyword "COMMIT".

SP8499.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8499E Invalid specification after keyword "ROLLBACK".

Explanation

Errors that cause this message to be output in the example above include:

  • An invalid word immediately following COMMIT.

  • An invalid word immediately following ROLLBACK.

Only the word WORK can be specified immediately following COMMIT or ROLLBACK.

ODBC-8503E

Keyword 'OF' is missing just after keyword 'CURRENT'.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8503.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011 01 VAR-IND      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 INTO :PRDCTNUM END-EXEC.
000020     EXEC SQL UPDATE WHERE CURRENT C1 END-EXEC
000021     EXEC SQL DELETE WHERE CURRENT C1 END-EXEC
000022     EXEC SQL CLOSE C1 END-EXEC.
000023    .

SP8503.cob (20) : JMN2633I-S The SQL statement is invalid. ODBC-8503E Keyword 'OF' is missing just after keyword 'CURRENT'.

SP8503.cob (21) : JMN2633I-S The SQL statement is invalid. ODBC-8503E Keyword 'OF' is missing just after keyword 'CURRENT'.

Explanation

In the above example, keyword OF must be specified after CURRENT in the UPDATE WHERE and DELETE WHERE clauses.

ODBC-8601E

Keyword 'USING' or keyword 'INTO' is duplicated.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8601.
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 01 SQLSTMT      PIC X(500).
000013     EXEC SQL END DECLARE SECTION END-EXEC.
000014 PROCEDURE DIVISION.
000015     MOVE "SELECT PNO FROM STOCK WHERE PNAME = ?" TO SQLSTMT
000016     EXEC SQL PREPARE STM1 FROM :SQLSTMT END-EXEC
000017     EXEC SQL EXECUTE STM1 USING :PRDCTNUM USING :PRDCTNAM END-EXEC
000018*
000019     EXEC SQL
000020       DECLARE C1 CURSOR FOR
000021         SELECT PNO FROM STOCK WHERE :PRDCTNAM = 'TIRE'
000022     END-EXEC
000023     EXEC SQL OPEN C1 END-EXEC.
000024     EXEC SQL FETCH C1 INTO :PRDCTNUM INTO :PRDCTNAM END-EXEC.
000025     .

SP8601.cob (17) : JMN2633I-S The SQL statement is invalid. ODBC-8601E Keyword 'USING' or keyword 'INTO' is duplicated.

SP8601.cob (24) : JMN2633I-S The SQL statement is invalid. ODBC-8601E Keyword 'USING' or keyword 'INTO' is duplicated.

Explanation

The example above contains the following errors:

  • Multiple USING phrases were specified in the EXECUTE statement.

  • Multiple INTO phrases were specified in the FETCH statement.

ODBC-8718E

INTO clause is specified in query expression.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8718.
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 INTO :PRDCTNUM FROM STOCK WHERE :PRDCTNUM = 1
000017     END-EXEC
000018     .

SP8718.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8718E INTO clause is specified in query expression.

Explanation

In the example above, an error is generated because an INTO phrase is specified in a DECLARE CURSOR statement.

ODBC-8725E

Embedded variable name "@1@" is not declared.

Parameter Explanation

@1@: Host variable name

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8725.
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       SELECT PNO INTO :PRDCTNM FROM STOCK WHERE :PRDCTNUM = 1
000016     END-EXEC
000017     .

SP8725.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8725E Embedded variable name "PRDCTNM" is not declared.

Explanation

The host variable not declared is used.

ODBC-8766E

Invalid specification in item be subordinate to SQL statement variable"@1@".

Parameter Explanation

@1@: Host variable name

Example 
000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8725.
000003 DATA           DIVISION.
000004 WORKING-STORAGE SECTION.
000005     EXEC SQL BEGIN DECLARE SECTION END-EXEC.
000006 01 STOCK-TABLE1.
000007   02 PRDCTNUM1   PIC S9(4) COMP-5.
000008   02 PRDCTNAM1.
000009     03 PRDCTNML1 PIC S9(4) BINARY.
000010     03 PRDCTNMS1 PIC N(8).
000011 01 STOCK-TABLE2.
000012   02 PRDCTNUM2   PIC S9(4) COMP-5.
000013   02 PRDCTNAM2   OCCURS 3 PIC X(10).
000014 01 STOCK-TABLE3.
000015   02 PRDCTNAM3   OCCURS 3 PIC X(10).
000016   02 PRDCTNUM3   PIC S9(4) COMP-5.
000017 01 STOCK-TABLE4.
000018   02 PRDCTNUM4   OCCURS 2 PIC S9(4) COMP-5.
000019   02 PRDCTNAM4   OCCURS 4 PIC X(10).
000020 01 SQLSTATE     PIC X(5).
000021 01 SQLMSG       PIC X(128).
000022 01 VAR-IND1     PIC S9(4) COMP-5.
000023     EXEC SQL END DECLARE SECTION END-EXEC.
000024 PROCEDURE DIVISION.
000025     EXEC SQL
000026       SELECT PNO INTO :STOCK-TABLE1 FROM STOCK WHERE PNAME = 'TIRE'
000027     END-EXEC
000028     EXEC SQL
000029       SELECT PNO INTO :STOCK-TABLE2 FROM STOCK WHERE PNAME = 'WHEEL'
000030     END-EXEC
000031     EXEC SQL
000032       SELECT PNO INTO :STOCK-TABLE3 FROM STOCK WHERE PNAME = 'SHIFT'
000033     END-EXEC
000034     EXEC SQL
000035       SELECT PNO INTO :STOCK-TABLE4 FROM STOCK WHERE PNAME = 'ENGIN'
000036     END-EXEC
000037     .

SP8766.cob (26) : JMN2633I-S The SQL statement is invalid. ODBC-8766E Invalid specification in item be subordinate to SQL statement variable"STOCK-TABLE1".

SP8766.cob (29) : JMN2633I-S The SQL statement is invalid. ODBC-8766E Invalid specification in item be subordinate to SQL statement variable"STOCK-TABLE2".

SP8766.cob (32) : JMN2633I-S The SQL statement is invalid. ODBC-8766E Invalid specification in item be subordinate to SQL statement variable"STOCK-TABLE3".

SP8766.cob (35) : JMN2633I-S The SQL statement is invalid. ODBC-8766E Invalid specification in item be subordinate to SQL statement variable"STOCK-TABLE4".

Explanation

The following host variables cannot be used.

  • Host variable which contains group item.

  • Host variable where host variable with multiple columns specified exists together to host variable with multiple rows specified.

  • Host variable with a table specified with different number of occurrence.

ODBC-8772E

Data type of SQL statement variable "@1@" must be character string type.

Parameter Explanation

@1@: Host variable name

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8772.
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 01 SQLSTMT1     PIC X(500).
000013 01 SQLSTMT2     PIC S9(9) COMP-5.
000014     EXEC SQL END DECLARE SECTION END-EXEC.
000015 PROCEDURE DIVISION.
000016     MOVE "SELECT PNO FROM STOCK WHERE PNAME = ?" TO SQLSTMT1
000017     MOVE 9999 TO SQLSTMT2
000018     EXEC SQL PREPARE STM1 FROM :SQLSTMT2 END-EXEC
000019     EXEC SQL EXECUTE IMMEDIATE :SQLSTMT2 END-EXEC
000020     .

SP8772.cob (18) : JMN2633I-S The SQL statement is invalid. ODBC-8772E Data type of SQL statement variable "SQLSTMT2" must be character string type.

SP8772.cob (19) : JMN2633I-S The SQL statement is invalid. ODBC-8772E Data type of SQL statement variable "SQLSTMT2" must be character string type.

Explanation

Errors that can cause this message to be output include:

  • The SQL statement variables of the EXECUTE IMMEDIATE statement are national item or not character strings.

  • The SQL statement variables of the PREPARE statement are national item or not character strings.

SQL statement host variables must be fixed-length or variable-length character strings of alphanumeric data item for these statements.

ODBC-8773E

SQL statement variable "@1@" must be a fixed length character string.

Parameter Explanation

@1@: Host variable name

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8773.
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 01 SQLCON1      PIC X(30).
000013 01 SQLCON2.
000014   02 CONLG      PIC S9(4) COMP-5.
000015   02 CONNM      PIC X(30).
000016     EXEC SQL END DECLARE SECTION END-EXEC.
000017 PROCEDURE DIVISION.
000018     MOVE 9           TO CONLG
000019     MOVE "DBCONNECT" TO CONNM
000020     EXEC SQL CONNECT TO :SQLCON2  END-EXEC
000021     EXEC SQL SET CONNECTION :SQLCON2 END-EXEC
000022     EXEC SQL DISCONNECT :SQLCON2 END-EXEC
000023     .

SP8773.cob (20) : JMN2633I-S The SQL statement is invalid. ODBC-8773E Data type of SQL statement variable "SQLCON2" must be fixed length character string type.

SP8773.cob (21) : JMN2633I-S The SQL statement is invalid. ODBC-8773E Data type of SQL statement variable "SQLCON2" must be fixed length character string type.

SP8773.cob (22) : JMN2633I-S The SQL statement is invalid. ODBC-8773E Data type of SQL statement variable "SQLCON2" must be fixed length character string type.

Explanation

Errors that can cause this message to be output include:

  • The connection identifier specified for the CONNECT statement is variable length.

  • The connection identifier specified for the SET CONNECTION statement is variable length.

  • The connection identifier specified for the DISCONNECT statement is variable length.

The server name, connection name, and user name must each be a character string literal or a host variable whose data type is fixed-length character string.

ODBC-8956E

Stored procedure name "@1@" is too long.

Parameter Explanation

@1@: stored procedure name

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8956.
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 X(20).
000009 01 SQLSTATE     PIC X(5).
000010 01 SQLMSG       PIC X(128).
000011     EXEC SQL END DECLARE SECTION END-EXEC.
000012 PROCEDURE DIVISION.
000013     EXEC SQL
000014       CALL PPPPPPPPP1PPPPPPPPP2PPPPPPPPP3PPPPPPPPP4PPPPPPPPP5PPPPPPPPP6PPPPPPPPP7
000015-           PPPPPPPPP8PPPPPPPPP9PPPPPPPP10PPPPPPPP11PPPPPPPP12PPPPPPPP13PPPPPPPP14
000016-           PPPPPPPP15PPPPPPPP16PPPPPPPP17PPPPPPPP18PPP()
000017     END-EXEC
000018    .

SP8956.cob (14) : JMN2633I-S The SQL statement is invalid. ODBC-8956E Stored procedure name "PPPPPPPPP1PPPPPPPPP2PPPPPPPPP3PPPPPPPPP4PPPPPPPPP5PPPPPPPPP6PPPPPPPPP7PPPPPPPPP8PPPPPPPPP9PPPPPPPP10PPPPPPPP11PPPPPPPP12PPPPPPP" is too long.

Explanation

A stored procedure name consisting of 91 or more characters is specified. A stored procedure name must be a list of alphanumeric characters of the appropriate language that does not exceed 90 characters.

ODBC-8957E

SQL statement is too long.

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8957.
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 01 SQLSTMT1     PIC X(16385).
000013     EXEC SQL END DECLARE SECTION END-EXEC.
000014 PROCEDURE DIVISION.
000015     EXEC SQL PREPARE STM1 FROM :SQLSTMT1 END-EXEC
000016     .

SP8957.cob (15) : JMN2633I-S The SQL statement is invalid. ODBC-8957E SQL statement is too long.

Explanation

A SQL statement is 16385 bytes or more. A SQL statement can be up to 16,384 bytes in length. The maximum length may be shorter depending on the ODBC driver environment.

ODBC-8992E

"@1@" is unsupported.

Parameter Explanation

@1@: clause

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8992.
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 01 SQLSTMT      PIC X(500).
000013     EXEC SQL END DECLARE SECTION END-EXEC.
000014 PROCEDURE DIVISION.
000015     MOVE "SELECT PNO FROM STOCK WHERE PNAME = ?" TO SQLSTMT
000016     EXEC SQL PREPARE STM1 FROM :SQLSTMT END-EXEC
000017     EXEC SQL EXECUTE STM1 USING DESCRIPTOR :PRDCTNAM END-EXEC
000018     .

SP8992.cob (17) : JMN2633I-S The SQL statement is invalid. ODBC-8992E "(SQL)DESCRIPTOR" is unsupported.

Explanation

A clause that is not supported by this compiler is used. The descriptor cannot be used by this compiler.

ODBC-8994W

Values in OCCURS clause as each SQL statement variable are different. Minimun"@1@" is valid.

Parameter Explanation

@1@: Minimum value of OCCURS clause

Example

000001 IDENTIFICATION DIVISION.
000002 PROGRAM-ID.    SP8994.
000003 DATA           DIVISION.
000004 WORKING-STORAGE SECTION.
000005     EXEC SQL BEGIN DECLARE SECTION END-EXEC.
000006 01 STOCK-TABLE.
000007   02 PRDCTINF   OCCURS 2 PIC X(1).
000008   02 PRDCTNUM   OCCURS 3 PIC S9(4) COMP-5.
000009   02 PRDCTNAM   OCCURS 4 PIC X(10).
000010 01 SQLSTATE     PIC X(5).
000011 01 SQLMSG       PIC X(128).
000012 01 VAR-IND1     PIC S9(4) COMP-5.
000013     EXEC SQL END DECLARE SECTION END-EXEC.
000014 PROCEDURE DIVISION.
000015     EXEC SQL
000016       SELECT PINF,PNO,PNAME INTO :PRDCTINF, :PRDCTNUM, :PRDCTNAM
000017                             FROM STOCK WHERE PNAME = 'TIRE'
000018     END-EXEC
000019     .

SP8994.cob (16) : JMN2754I-I ODBC-8994W Values in OCCURS clause as each SQL statement variable are different. Minimun"2" is valid.

Explanation

The occurrence number specified in the subordinate items of a host variable with multiple rows specified and host variable with a table specified used in one SQL statement must all be the same. If they are not the same, the smaller number is used.