Using dictionary variable in the query

sergii.chukhno

• February 03, 2014 00:00

• Answered

Follow

Hi all,

Could you please give me advice concerning to the using dictionary variable in the "where" clause of the query in DB Input Table component.

I don't know which format is ?

Thanks a lot
in advance

• 

  sergii.chukhno

  • February 05, 2014 14:02

  0

  Comment actions Permalink

  Hi all,
  
  Could you please give me advice concerning to the using dictionary variable in the "where" clause of the query in DB Input Table component.
  
  I don't know which format is ?
  
  Thanks a lot
  in advance

  
  
  
  Please close this topic. I have resolved this problem.
  
  Thanks.
• 

  admin

  • February 05, 2014 14:08

  0

  Comment actions Permalink

  Hi Sergii,
  
  Unfortunately using dictionary in DbInputTable is not supported.
  
  Instead please:
  * prepend DataGenerator in front of DbInpuitTable and set it to produce exactly one record
  * in transformation of DataGenerator generate your SQL query using http://doc.cloveretl.com/documentation/ ... -ctl2.html
  * connect DataGenerator and DbInputTable via edge using metadata containing at least single string field (containing SQL query)
  * set DbInputTable to read data from input port; see input port section of http://doc.cloveretl.com/documentation/ ... table.html for details
  
  Please let me know if you have further questions.
• 

  sergii.chukhno

  • February 06, 2014 11:29

  0

  Comment actions Permalink

  Hi Kubosj,
  
  I have resolved it by added ExtFilter after DbInputTable component and posted there condition with dictionary entry.
  
  Thanks a lot.
• 

  paulhbartosik

  • December 06, 2017 13:56

  0

  Comment actions Permalink

  Is this still true in the current version?
  
  I have many graphs that I set up with parameters. Most of those use the parameters in the where clause of SQL queries. If I want to convert these to Launch Services on my CloverETL server, do I have to convert all of those parameters to dictionary entries, or is there another way?
  
  Thanks for any suggestions.
  
  -Paul
  
  
  

  Hi Sergii,
  
  Unfortunately using dictionary in DbInputTable is not supported.
  
  Instead please:
  * prepend DataGenerator in front of DbInpuitTable and set it to produce exactly one record
  * in transformation of DataGenerator generate your SQL query using http://doc.cloveretl.com/documentation/ ... -ctl2.html
  * connect DataGenerator and DbInputTable via edge using metadata containing at least single string field (containing SQL query)
  * set DbInputTable to read data from input port; see input port section of http://doc.cloveretl.com/documentation/ ... table.html for details
  
  Please let me know if you have further questions.

• 

  Pedro Vazquez Rosario

  • December 07, 2017 15:49

  0

  Comment actions Permalink

  Hi Paul,
  
  This is still true in the current version of CloverETL, unfortunately, dictionaries are not supported in DBInputTable. On a side note, if you are using CloverETL 4.7 we introduced an improved version of Launch Services called Data Services. If you would like to know more I have added a few links that explain how it works.
  
  Data Service Documantation
  
  Data Service Blog

Please sign in to leave a comment.