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

0 Likes
over 1 year ago

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.

 

 

 

Comment List
Anonymous
Related Discussions
Recommended