just a random pick

SQL Code : -113

INVALID CHARACTER FOUND IN string, REASON CODE - nnn

Explanation :

The string contains an invalid character.It can be an SQL ordinary identifier name, a hostvariable name, or a DBCS comment.

Certain SQL identifiers (for example names of bufferpools, databases, and plans) must contain onlyuppercase alphabetic or national characters andnumerics; the first character must be alphabetic ornational.

SQL STATE : 42602

When DB2 executes an SQL statement, it returns information about the statement execution which includes the SQL return code (SQLCODE) and the SQLSTATE, which indicate whether statement execution was successful.

Regardless of whether the application program provides an SQLCA or a stand-alone variable, SQLCODE is set by DB2 after each SQL statement is executed. DB2 conforms to the ISO/ANSI SQL standard as follows:

  • If SQLCODE = 0, execution was successful.
  • If SQLCODE > 0, execution was successful with a warning.
  • If SQLCODE < execution was not successful.

Suggestion / Complaint / Feedback