JDBC Receiver

[Former Member]

Hi Frnds,

I wld like 2 know while updating 2 or more record of a single databse table what is the structure u need to give in mapping.. or it wld b esay to write a stored procedure.

What is the difference between ACCESS and KEY tag?

Thanks,

Nilakantan.S.

[former_member194786 · Accepted solution]

Hi Nilakantan,

For updating more than one records you create the query structure with Statement having the occurence as 0..unbounded. Thus for each input message you can create an update statement.

Access tag is used to specify the records that you will use for the update(Field names which are to be updated). Key tag specifies the condition for selecting the records(Where clause of sql statement).

Regards,

Sanjeev.

[Former Member]

HI,

You can use the structure for update as mentioned in this link.

http://help.sap.com/erp2005_ehp_03/helpdata/EN/22/b4d13b633f7748b4d34f3191529946/frameset.htm

The access element contains the table columns which are to be accessed. It must be specified as the first element

The key elements describe a condition for access.

[dharamveer_gaur2]

single stuctue can updat your multiple record,use 0...unbound at reciever stucture.

Acess-> column that u want to insert.

key->column that is used for where condition updation record.

[Former Member]

Hi !

for difference between ACCESS and KEY tag

refer this link

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

[Former Member]

hi

ACCESS contains the column values of the database table and

KEY determines the condition.

regards

kummari

[Former Member]

Hi ,

can u plz give me a example as i m new 2 Xi ?

Also can u give me an example where 2 or 3 records of a single databse table has been updated...(Structure of mapping.)