Hi
Scenario: File-JDBC-File
MT_sender Mapping MT_Receiver
Record (1..1) Field1 to statement Statement 1..Unbound
Field1(1..unbound) TableName
Action ( SELECT )
Access
Field2
Key 1..1
Field1 to Field1 Field1 1..1
in above case statement_response will be occurence 1..unbound..as we are executing multiple queries.in my case field1 in sender side are upto 400 values.then in that case is it better to do as option-1 or as below
MT_sender Mapping MT_Receiver
Record (1..1) no mapping Statement 1..1
Field1(1..unbound) TableName
Action ( SELECT )
Access
Field2
Key 1..1
Field1 to Field1 Field1 1..unbound
in this case the single query executes like select field2 from table where (field1=1 or field1=2.........field1=400).
Which is better option
other option is write a query using DML operation using place holders.But can we give multiple values in place holders as input to the query using IN operator.. can we do like this??
Thanks
Edited by: murali krishna on Apr 9, 2010 3:19 PM