HomeDB2DB2 Error Code – -113 invalid character found in name: name.

DB2 Error Code – -113 invalid character found in name: name.

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.

Share:

Leave a Reply

You May Also Like

In this post, you’ll learn about the error message -952 processing was interrupted by a cancel request from a client...
  • DB2
  • November 21, 2022
In this post, you’ll learn about the error message -927 the langrage interface was called when the connecting environment was...
  • DB2
  • November 21, 2022
In this post, you’ll learn about the error message -926 rollback not valid in ims/vs or cics environment in the...
  • DB2
  • November 21, 2022