action delete in SQL

[Former Member]

Hi ,

Just need to check on the structure of data for delete action in SQL

will the data type be

Statement

table name

action

table

key

or

Statement

table name

action

key

As shown in the documentation for JDBC data structure i cant find table field . But how can it be possible to delete rows without a table name??

Mudit

[Former Member]

Hi,

Check this For More Clarification

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

REgards

Seshagiri

[Former Member]

Hi Mudit Mehra,

The Standard JDBC Structure is

.STATEMENT NAME

..TEST

...ACTION is Attirbute

...TABLE

..ACESS

u can spiecy the Delete option in ACTION Field.

Regards,

Sateesh

Edited by: Sateesh N on May 22, 2008 8:57 AM

[Former Member]

Hi

I also am thinking on the same lines but the sap documneting is confusing me .It says the structure will be

<StatementName3>

<dbTableName action=u201DDELETEu201D>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

</dbTableName>

</StatementName3>

Here there is no table node

Mudit