...
2 When an SQL view uses derived character fields, then the CCSID of the field is sometimes 65535; hence, the DB-driven widget fails. Casting the character field with the CCSID parameter is one way to fix the problem. For example, even though the underlying fields have CCSID of 37, the following clause has a CCSID of 65535:
...