Data360 Analyze

 View Only

  • 1.  SqlQueryFieldBindings

    Employee
    Posted 02-10-2021 09:50

    Hello:  Getting the following error when running a JDBC query using the SqlQueryFieldBindings.  I am trying to use a field from an output file as the search criteria for the query below.

     



  • 2.  RE: SqlQueryFieldBindings

    Employee
    Posted 02-10-2021 10:49

    What is the error?



  • 3.  RE: SqlQueryFieldBindings

    Employee
    Posted 02-10-2021 10:55

    Hello:

    Error is in text attachment

     

     

    Attached files

    data360 error.txt

     



  • 4.  RE: SqlQueryFieldBindings

    Employee
    Posted 02-11-2021 08:53

    I'm not familiar with Teradata but the JDBC Query error appears to indicate that you may have an invalid character in your input data:

    [TeraJDBC 16.10.00.03] [Error 2621] [SQLState HY000] Bad character in format or data of crdt_app.acct_nbr.

    The SQL statement is casting the input value to a BIGINT:

     "SELECT "base_view"."acct_nbr" FROM "EDWCCDVIEWS"."crdt_app" "base_view" WHERE CAST("base_view"."acct_nbr" AS BIGINT) = 464132813965"

     

    When I did a basic test against a Teradata DB the syntax/ node configuration worked ok:

     



  • 5.  RE: SqlQueryFieldBindings

    Employee
    Posted 02-11-2021 08:54

    Here is the Teradata documentation on the 2621 error:

    https://www.docs.teradata.com/r/8MhLDQBmL52OycrEKPuGqg/mzvswDmIHdZK~VszhuBRtw