Skip to Content
author's profile photo Former Member
Former Member

JDBC Receiver

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    Posted on Sep 22, 2008 at 07:05 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2008 at 06:44 AM

    hi

    ACCESS contains the column values of the database table and

    KEY determines the condition.

    regards

    kummari

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2008 at 06:45 AM

    Hi !

    for difference between ACCESS and KEY tag

    refer this link

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 22, 2008 at 06:47 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2008 at 06:50 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.