Support for the TRY_CAST built-in SQL function

[calexander]

Support for the TRY_CAST built-in SQL function would be very useful. TRY_CAST returns null when not able to cast, which makes it very flexible. If I try to use it now in a data source, it won't accept it even though it is valid SQL.

Select TRY_CAST('123' as Dec(9)) as goodNum,              -- returns 123
       IfNull(TRY_CAST('abcd' as Dec(9)), 0) as badNum    -- returns 0
From SysIBM/SysDummy1?

Thanks!

[Johnny Major]

Thanks for letting us know and this will be available in the next 6.3 update;