Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hello everyone,
I am trying to use a "long" variable in a Teradata SQL Connection - that I am calling long because when I am using a smaller one it's working - that raises an error when trying to use it.
In my query I am using the variable as follow :
g.CUOAFFECTAGT not in ('${Codes}')
My Code variable looks like this :
"Codes": "3101,3102,3103,3106,3107,3108,3109,3144,3145"
It works, but if I had some more codes it doesn't work anymore :
g.CUOAFFECTAGT not in ('${Codes2}')
"Codes2" : "3101,3102,3103,3106,3107,3108,3109,3144,3145,3147,3166,3167,3168,3182,3183,3184,3188,3189,3194,3197,3198,3375,3376,3377,8082"
I have the following error :
Connection OK, but query failed: Failed to read data from DB, caused by: SQLException: [Teradata Database] [TeraJDBC 17.00.00.03] [Error 3535] [SQLState 22003] A character string failed conversion to a numeric value.
I don't really understand from where can come the trouble and I am not able to cast anything in my IN condition.
That's why I am reaching you for help.
Thanks a lot.
Hadrien
Operating system used: Windows
Operating system used: Windows