Variable in SQL insert statement
I defined a variable with 'FileName' and assigned a value to it.
No I am trying to use this variable in the INSERT INTO statement.
cursor.execute("INSERT INTO etlbatch (source) VALUES ('FileName')")
When I try to run the above as a Jython Script it is inserting FileName into the column instead of the Value in the variable(FileName). Can you please help me with this.