DBInput Table, v. 3.1 - how to refer to input port in SQL

vmyplisher

• July 22, 2011 00:00

• Answered

Follow

In a DBInputTable I would like to refer to the data being passed via the IN port.

Scenario:
In DBInputTable0 I am querying to obtain a varchar(10) string, then outputting it to DBInputTable1 (to DBInputTable1 input port).

In DBInputTable1 I would like to use that string in the SQL statement. How?

Many thanks for your help!

• 

  avackova

  • July 25, 2011 12:09

  0

  Comment actions Permalink

  Hello,
  probably the easier way for this scenario is to use DBJoin component instead of 2nd DBInputTable but it depends on the query you want to execute. To do it with DBInputTable, you need to transform the obtained string in Reformat component, to create a query, that can be sent to DBInputTable.

Please sign in to leave a comment.