Structure to be maintained in proxy to jdbc scenario

[Former Member]

Hi all ,

There is a field Flag ,which receives the value from the database table.if the flag value is 0 then nothing should be done ,if the flag value is 'S' then the correspong record must be removed from the JDBC data base table.

I am already using the action UPDATE_INSERT for over writing the existing record.

In the ztable ,I am maintaing a zield Flag(change indicator).If this change indicator is S then, record must be deleted from jbdc.

How to maintain jdbc structure .

Thanks,

Srinivasa

[MichalKrawczyk · Accepted solution]

hi,

for all operations you always check out the same page:

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

Michal Krawczyk

http://mypigenie.com - XI/PI FAQ

[Former Member · Accepted solution]

Can I use structure as this one?

Target->Statement->Attachments-

action=UPDATE_INSERT

table=Mytable

->access-

Field1

Field2

Field3

Field4 ->

<Statement>

<Mytable action=u201DDELETEu201D>

<key1>

<Field1>S</Field1>

</key1>

</Statement>

Here I am using both Update_insert and Delete operations on same table.

Thanks,

Srinivasa

[Former Member · Accepted solution]

Hi Srinivas,

As per the structure you can use the link given by Michal, But please be clear what exactly is your issue now.

Thanks

Prabhakar

[Former Member · Accepted solution]

Hi

Structure you defined should work for you. But make sure to send messages as EOIO to avoid redundancy of data at any time.

Thanks

Gaurav

[Former Member]

> How to maintain jdbc structure .

Hi,

In addition to the above replies, refer this blog too...

Regards,

Sarvesh