An attempt to set the IN parameter has failed. (DataSource name = aa....aa, SQL ID = bb....bb, parameter element = cc....cc, data type = dd....dd, error information = ee....ee, SQL state = ff....ff, error code = gg....gg)

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 executing a single SQL statement	When executing multiple SQL statements#
SQL identifier name	SQL identifier name (Position)

#

Out of the DBA_MULTI_SQL elements in the request message, the position of the corresponding DBA_MULTI_SQL element is displayed with numeric characters. The position starts from 1.

cc....cc: Argument element name
dd....dd: Value of the attribute data_type in the SQL operation definition file
ee....ee: DBMS-specific error message
ff....ff: SQL status

• In HiRDB: SQLSTATE
• In Oracle: Code indicating the SQL status
• When the SQL status cannot be acquired: *

gg....gg: SQL code

• In HiRDB: SQLCODE
• In Oracle: ORA number

Description

An attempt to set the IN parameter failed.

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

(S)

Cancels the processing.

(O)

Check whether the value of the data_type attribute in the SQL operation definition file matches the value corresponding to the data type in the database. If the values match, remove the cause of the error on the basis of this message and the DBMS error information. If the error cannot be removed, collect the log and trace information, and then contact maintenance personnel.