Skip to main content

COBES0100 DB2 Parser error: Syntax error...' when optional keywords INTO or FROM are omitted

  • October 24, 2020
  • 0 replies
  • 1 view

Problem:

Compiler error COBES0100 : DB2 Parser error: Syntax error near.... is occurring when the optional INTO or FROM keywords are omitted from EXEC SQL INSERT and EXEC SQL DELETE statements.
 

Solution:

In later versions of Enterprise Developer like 5.0, the SQL directive STRICTPARSE is on by default, and it flags statements that do not compile on the mainframe, like INSERT without the INTO or DELETE without the FROM. Adding the NOSTRICTPARSE directive resolves the issue.

 

 

 


#MFDS
#EnterpriseDeveloper

0 replies

Be the first to reply!