Is there any way to identify the exact line number or SQL code which is throwing "SELECT Failed. 2620: The format or data contains a bad character." issue?
Most of the cases I used to run SQL queries with 200+ lines and I'm getting this issue due to bad data model. Its taking huge amount of time to identify the exact line number which is causing this issue and we are casting it.
So it will be very helpful if we know the line number of the issue to fix it.
only the position of a syntax error is returned (when you connect using .NET).
But in your case it's a runtime error and then the actual column causing that is not included.
When you check Explain you can search for (FLOAT, FORMAT '-9.99999999999999E-999') as it's usually a VarChar compared/joined to a numeric value.