logo  
Google
 

DB2 SQL-Error: -113

SQLState: 42602

Short Description: INVALID CHARACTER FOUND IN REASON CODE

The string contains an invalid character. It can be an SQL ordinary identifier name, a host variable name, or a DBCS comment. For SBCS SQL ordinary identifiers, names of buffer pools, databases, plans, and storage groups must contain only uppercase alphabetic or national characters and numerics when CHARSET is KATAKANA; the first character must be alphabetic or national. In some cases, the name of an SQL procedure can contain an underscore character. Please see the DB2 SQL Reference for more information. The following reason codes apply to SBCS identifiers: 000 An invalid character was found in the SBCS identifier (including the case in which a DBCS identifier was used where only an SBCS identifier is allowed.) The following reason codes apply to DBCS identifiers or comments: 101 An odd number of bytes exists between the shift-out and the shift-in character. 102 Either a shift-in or shift-out character is missing. 103 DBCS blanks XÂ’4040Â’ are not allowed. 104 There are no characters between the shift-out and the shift-in characters. 105 Shift-out cannot be the first byte of the DBCS character between the shift-out and the shift-in characters.System action: Processing is terminated. User response: Correct the name.

 <-  BACK TO INDEX