At first i thought it was one of those famous typos but you're right.
(nothing can beat the Onions anyway...)
Additional info :
db2 values cast('x' as varchar(20) for mixed data)
for non mixed. ie sbcs,dbcs,mbcs. (unicode)
Found about the topic in the imcompatibilities section but not in most
'cast' related doc sections.
Version 8 incompatibilities with previous releases on
http://publib.boulder.ibm.com/infoce...help/index.jsp
PM
"Serge Rielau" <sr*****@ca.eye-bee-m.com> a écrit dans le message de
news:bq**********@hanover.torolab.ibm.com...
Depending on your version of DB2 (V8.1 GA I think)you can cast to
databse codepages:
CAST(c1 AS CHAR(n) FOR SBCS DATA)
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab