JDBC receiver Statement UPDATE_INSERT

[Former Member]

Hello,

adapter JDBC receiver when statement is:

UPDATE_INSERT ¿how many STATEMENT count returns?

one for all insert and other by all update? or one for each insert and one for each update?

thanks very much

[Former Member]

thanks Shabarish,

What must be the response data type, so?

dt_jdbc_response

STATEMENT_response

insert_count

STATEMENT1_reponse

update_count

?

thanks very much

[Shabarish_Nair]

help yourself

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

[Shabarish_Nair]

in case you want to be sure, you can also ref help;

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:

<update_count>count</update_count>

<insert_count>count</insert_count>

<STATEMENT_response>

<update_count>count</update_count>

<insert_count>count</insert_count>

to cross confirm you can actually test the scenario and look into the response message in SXMB_MONI and create the structure accordingly

[Former Member]

Thanks Michael,

but i had seen the help sap, and don't soved my doubt

i want to know if i send 3 statement for jdbc receiver for update_insert, how many messages are return?,

1.- two -> <update_count>3</update_count>

<insert_count>0</insert_count>

2.- various -> <update_count>1</update_count>

<update_count>1</update_count>

<update_count>1</update_count>

<insert_count>0</insert_count>

<insert_count>0</insert_count>

<insert_count>0</insert_count>

?

I need mapping both messages (update_count and insert_count) or only one is ok?

[Shabarish_Nair]

1.- two -> <update_count>3</update_count>

<insert_count>0</insert_count>

[MichalKrawczyk]

Hi,

as per docu says:

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

does it answer your question ?

Regards,

Michal Krawczyk