SQL Codes › SQL Return Codes -1 through -999 › -105 - aaa IN bb

-105 - aaa IN bb

Reason:

There is an invalid DBCS or mixed-case literal or identifier.This message is used for anything invalid found in the plan name (output from PLNMNT). The text in the message varies where aaa is one of the following:

• ODD BYTE COUNT
• SHIFT CHARACTER(S) MISMATCHED
• INCORRECT CHARACTER(S) FOUND
• EMPTY DBCS STRING (only when bb is MIXED IDENTIFIER)
• DBCS BLANK FOUND (only when bb is MIXED IDENTIFIER)
• CONSECUTIVE SHIFT CHARACTERS (only when bb is MIXED IDENTIFIER)
• ILLEGAL/INCORRECT CHARACTER FOUND

And bb is one of the following:

• GRAPHIC LITERAL
• GRAPHIC LITERAL(PLI-STYLE)
• MIXED-STRING LITERAL
• MIXED IDENTIFIER
• PLAN NAME

The SQLSTATE that equates to this SQL return code is 42604.

Action:

Correct the DBCS or mixed-case literal. If you are unable to locate the bad literal, print a PXX report and find the line that starts with "OFFSET TO BAD DBCS STRING." The number printed is an approximation of the number of characters that precede the bad string in your SQL statement syntax. The number does not include carriage control or linefeed characters and is only an estimate, but should be close enough to help direct you to the problem string.