Skip to Content
0
Apr 09, 2010 at 12:01 PM

Receiver JDBC structure

104 Views

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