Toad World® Forums

TRY_CAST in DB2

Hi all,

I’m looking for a solution which can provide ‘error handling’ when I’m for example trying to cast ‘abcd’ as date. I know that in MS SQL Server there is such a solution (function TRY_CAST) but I can’t find nothing about that in DB2.

Can anybody help me?

DB2 does have a CAST function, but it is not as robust as the MS TRY_CAST function. I would suggest to open an enhancement request with IBM DB2 to address your request for such function.