An SQL statement has a syntax error. (DataSource name = aa....aa, SQL ID = bb....bb, error information = cc....cc, SQL state = dd....dd, error code = ee....ee)

aa....aa: Database reference name

• Optional name of the resource specified in the header variable if the destination is changed dynamically

bb....bb: SQL identifier name

• When a single SQL statement is executed: SQL identifier name
• When multiple SQL statements are executed^#: SQL identifier name (Position)
  Note#
  From among the DBA_MULTI_SQL elements in the request message, the position of the relevant DBA_MULTI_SQL element is displayed with numeric characters. The position starts from 1.
  

cc....cc: DBMS-specific error message
dd....dd: SQL status

• In HiRDB: SQLSTATE
• In Oracle: Code indicating the SQL status
• If the status cannot be obtained: *

ee....ee: SQL code

• In HiRDB: SQLCODE
• In Oracle: ORA number

Description

An attempt to execute the SQL statement failed because of a syntax error in the SQL statement. This message is also output when you specify an SQL statement containing a data type that is not supported by the JDBC driver used by DB Connector for the search results, or when the database cannot be accessed.

When multiple SQL statements are executed, the information about the error that is detected first will be output.

(S)

Processing is cancelled.

(O)

• When the cause of the error is a syntax error in the SQL statement
  Eliminate the cause of the error on the basis of this message and the DBMS error information.
  
• When the cause of the error is not a syntax error in the SQL statement
  Eliminate the cause of the error on the basis of this message and the DBMS error information. If the error cannot be corrected, collect the log and trace information, and then contact maintenance personnel.