In this post, you’ll learn about the DB2 error 257-Implicit conversion from datatype ‘VARCHAR’ to ‘TINYINT’ is not allowed. Use the CONVERT function to run this query. and the reason why you are receiving the error message and how to fix it
How does this Error Message Looks like
257 – Implicit conversion from datatype ‘VARCHAR’ to ‘TINYINT’ is not allowed. Use the CONVERT function to run this query.
Reason for the Error & Solution
A string field is stored in a column of numeric type. Sybase disallows querying against these fields.