openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Patrick Linskey" <>
Subject DB2: CAST and VARCHAR
Date Thu, 06 Sep 2007 21:11:52 GMT

Is it ever valid in DB2 to just do a 'CAST(? AS VARCHAR)', or must it
always be a 'CAST(? AS VARCHAR(<length>))'?

The current DB2 dictionary does the former; I'm working on some code
that puts a parameter into the SELECT clause, and to get that to work,
I need to make the CAST include the length information.  Should I be
changing the addCastAsType() method in DB2Dictionary, or just doing
the length bit in my particular situation?


Patrick Linskey
202 669 5907

View raw message