Query in Insert statement with JDBC Rx adapter

[Former Member]

Hi,

This is a FILE to JDBC scenario.

My target datatype is like this with sample payload values

statement_s

statement_s

action='INSERT"

access

A=1234

B=1002

key

A=1234

B ="10%"

compareOperation= LIKE

A(1..1) is primary key in DB and B(0..1) colunm is an optional one.

I want to know if such kind of Insert query with(LIKE operator) is possible.

Please reply me ASAP.

Edited by: ram pranav on Feb 18, 2009 10:28 PM

[Former Member]

Also,

we dont use KEY tag in INSERT statement...

Here is the document format for INSERT operation in the Receiver JDBC :

<StatementName2>

<dbTableName action=u201DINSERTu201D>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<access>

<col1>val11</col1>

</access>

</dbTableName> 

  </StatementName2>

Check the following link for more details : http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Thanks,

Pooja Pandey

[Former Member]

Hi Ram,

Why do you need a "LIKE" operator in your INSERT statement ?

Thanks,

Pooja Pandey

[Former Member]

Hi,

This is my actual target payload, For this record I require an Insert query (as this record is not present in DB T1).

<Statement_T1>

<T1 action="UPDATE_INSERT">

<access>

<A>1234</A>

<B>1001</B>

</access>

<key>

<A>1234</A>

<B compareOperation="LIKE">10%</B>

</key>

</T1>

</Statement_T1>

Please confirm if Insert is possible in this case.

Regards,

Pranav.

[Former Member]

Hi Ram,

IN case of "UPDATE_INSERT", you can use the KEY tag in your structure. Also you can provide LIKE as an attribute to the KEY element as follows :

<key1>

<col4 compareOperation=u201DLIKEu201D>val%</col4>

</key1>

But when you are trying to insert the data_, the <key> tags will be ignored and only <access> will be considered._

action=UPDATE_INSERT

The statement has the same format as for the UPDATE action. Initially, the same action is executed as for UPDATE. If no update to the database table can be made for this action (the condition does not apply to any table entry), values of the table described in the <access> element are inserted in accordance with the description of the action INSERT. <key> elements are ignored in this case.

The response document has the following format; one of the two values is always 0 because either an UPDATE or an INSERT action is always executed:

Go through the link I have provided earlier.

Thanks,

Pooja Pandey