Invalid SQL statement or JDBC escape

[HJlassi1619437866]

Hello everyone,

I hope you're doing well,

I'm having an error in reading a string global map variable in a query clause

I get this error every time i ran my job "tdbInput 10 Invalid SQL statement or JDBC escape, terminating ''' not found"

here i get my string, than i just use a "globalMap.put("SERVICE_EMAIL", input_row.SERVICE_EMAIL);" in "tJavaRow"

Than i try to use it in another tdbinput (Microsoft Sql Server)

And i get this error "tdbInput 10 Invalid SQL statement or JDBC escape, terminating ''' not found"

Have anyone face it before ?

I'll appreciate your help, thank you.

[MattE]

The problem isn't with the global variable it is that your SQL statement is incomplete. You need to wrap the string in single quote

"...where lower(b.[eme_email]) in ('"+(String)globalMap.get("service_email)+"')"