In this post, you’ll learn about the error message -113 invalid character found in name: name. in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-113 invalid character found in name: name.
Reason for the Error
The name contains an invalid character.� The name can be an SQL ordinary identifier name or a host variable name.For SBCS 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.The following reason codes apply to SBCS identifiers:000����������� An invalid character was found in the SBCS identifier (including the situation where a DBCS identifier is used where only an SBCS identifier is allowed.)The following reason codes apply to DBCS identifiers.101���������� An odd number of bytes exists between the shift-out and the shift-in.102� No shift-in was found at the end of the identifier.103 DBCS blanks X’4040′ are not allowed.104��� There are no characters between the shift-out and the shift-in.105�� Shift-out can not be the first byte of the DBCS character between the shift-out and the shift-in.
Solution
Correct the name.
