Skip to Content
avatar image
Former Member

Receiver JDBC

Hi

the receiver JDBC structure

                                                                   occurence
<statement1>   ----------------------------->                   1..unbound    or    1..1                               (1)
<Table>            ----------------------------->                1..1 per statement always                             (2)
<access>         ----------------------------->                  1..1 per statement always                             (3)
   <fld1></fld1>                                          
   <fld2></fld2>
</access>
<key> --------------------------------------->                   1..unbound    or  1..1                                       (4)                           
  <val1>
</key>
</statement1>
 
<statement_response>  --------------->                        should be 1..unbound <b>if</b> statement request is 1..unbound (here statement1)
                                                                                should be 1..1 <b>if</b> statement request is 1..1 (here statement1)                        (5)
<row>                                        
<row>
</statement_response>

-&gt; In which case we go for occurrence of statement (here statement1) = 1..unbound ??

-&gt; if i need to select from one table do i need to use this as 1..unbound ?? Yes/No

--&gt;each statement response (means all rows of that query) will come under row node with multiple occurrence Yes/No??

--&gt;if i want to delete the rows from table where col= (value array) in this case i have to give key occurence as 1..unbound??Yes/NO

--&gt;if i want to select all the data from one table..i no need any key..but as per sap help doc..if we dont specify the key the adapter will not accept and shows some error message...so i should some dummy key value..and need to compare with NEQ to NULL or space???

--> If i want to select the data from JDBC using the receiver structure...can i declare all the field types as string in request and response structure..or it should match the data types of fields in data base..?? if so how it should be in select request and response structure??

(1) (2) (3) (4) (5) are right or wrong..if wrong correct me..

Thanks

krish

Edited by: murali krishna on Mar 24, 2010 5:30 PM

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Mar 25, 2010 at 04:37 AM

    Hi Raj,

    Thanks for the immediate response.Wht abt my 4th question

    -->if i want to select all the data from one table..i no need any key..but as per sap help doc..if we dont specify the key the adapter will not accept and shows some error message...

    so i should some dummy key value..and need to compare with NEQ to NULL or space???

    Regards,

    Krish

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      -->if i want to select all the data from one table..i no need any key..but as per sap help doc..if we dont specify the key the 
      adapter will not accept and shows some error message...

      No we dont need any key when all the data has to be selected...actually not defining a key is an indicator to select the entire table.

      From the help section: http://help.sap.com/saphelp_nwpi71/helpdata/EN/44/7b7171fde93673e10000000a114a6b/content.htm

      u25CB       If you do not define the <key>element, or if you define an empty <key> element, this means that no condition is 
      specified and that the entire table is to be selected. If you want to ensure this does not happen, select Key Tags Mandatory in the 
      adapter configuration.

      Regards,

      Abhishek.

  • Mar 24, 2010 at 06:20 PM

    Krish,

    Please see the below response

    Answer-1

    If you are selecting data from Different tables then you need to define Statement as 1.. Unbounded

    Answer- 2

    No. Since you are selecting data from one table - you can define it as 1..1

    Answer -3

    There will be only one Statement_Response per Statement. In other words if you have Multiple Statement in the Request , then you will have Multiple Statement(x)_Response

    So Under Statement_Response you will have Multiple Rows(for each record in the database) . YES - Row has to be 0.. Unbounded

    Answer- 4

    YES - You are correct

    Answer-5

    YES - you can define them all as a STRING. It shouldn't be a problem

    Hope it helps!

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 25, 2010 at 04:56 AM

    Hi Abhishek,

    i am using same receiver JDBC adapter to select and after sending the data to target i am deleting those entries that are selected using same JDBS receiver adapter.

    while deleting i am using key fiels. In this case is it safe to deselect key fields manditory check box.??

    Add comment
    10|10000 characters needed characters exceeded