Was trying to help this poster to Stack Exchange..
I created a test file with a single field named test with a CCSID
The DB is perfectly happy with this:
, cast(substr(test,7,3) as char (3) CCSID 37)
, cast(substr(test,1,6) as nchar)
returns SQL0332 - Character conversion between CCSID 65535 and CCSID
1200 not valid
This also returns an SQL0332
, cast(substr(test,1,6) as char (6) CCSID 13488)
It seems to me that if the DB is going to allow any cast from 65535,
it should allow them all.