teradatateradata-sql-assistant

How to find the line number of error in Teradata SQL Assistant


I'm new to Teradata SQL Assistant and have a simple issue that couldn't find the solution in Terada documentations. I see the below Error

How I can find the exact location of this error?


Solution

  • You need to parse the input and find strings that don't conform to your expectations.

    For example...

    SELECT
      *
    FROM
      your_table
    WHERE
      TryCast(your_column AS INT) IS NULL
    

    https://docs.teradata.com/r/Teradata-Database-SQL-Functions-Operators-Expressions-and-Predicates/March-2017/Data-Type-Conversions/TRYCAST/Syntax-Elements/data_type