JDBC execute - use input in SQL querry

Follow

felix.stuyck

• January 08, 2020 14:16

Hi,

I am trying to use input data in my SQL code, but something seems wrong. 
The goal is to remove the records form an SQL table that have a Run_date that i specify in D3S.

Code in the JDBC execute node is as follows:
The column Run_date in my SQL table is of type date.

The input data looks as follows:
 Alternatively I tried inputting a string.
Both cases the error message was:

How do I use input data as a criteria in my SQL code?

0

• 

  Gerry Mullin

  • January 09, 2020 01:35
  • Edited

  You don't need to use the 'Use DbName' in the node. You should have that specified in your connection details. Then to reference your fields on the input pin you specify them in the SqlQueryFieldBindings and reference them (in order) with a ?.

  In screenshot example attached, I have a table called people with first and last names in it, I want to delete the rows that match the field LastName on my input.

   

  The help documentation explains it well also.

   

   

  Attached files

  delete_sql.png

   

  0

  Comment actions Permalink
• 

  felix.stuyck

  • January 09, 2020 11:11

  The ? worked!
  Indeed the DBname in the code was redundant and specified in the connection details.
  
  Thank you for the help!

  0

  Comment actions Permalink

Please sign in to leave a comment.