Attributes actions

[Former Member]

Hi Experts

In JDBC adapter, when we use mapping do we have to always map the attribute, action ? Or is it to be mapped only during INSERT. Do we have to map access tag also always ? Access block won't be there in DELETE. So how do we map ACCESS in the Data Type ? And also is ACCESS always 1: unbounded ? Do we have to map the condition in WHERE Clause specified in the Update SQL Statement under Processing Parameters of JDBC Adapter ?

Radhika

[former_member200962 · Accepted solution]

The action attribute has to be mapped for all the actions (INSERT, UPDATE, DELETE) that are done on the DB.

The Access element actually represnt the table in the DB ... the chile elements under Access represent the Columns of the Table.

Since a table is supposed to have a min of one Column entry (max entries depend on the business need) hence the occurence is 1..unbounded.

Regards,

Abhishek.

[Former Member · Accepted solution]

Thabks Abhishek

So if the ACTION is SELECT then it does not have to be mapped ?

Radhika

[former_member200962 · Accepted solution]

>

> So if the ACTION is SELECT then it does not have to be mapped ?
> Radhika

Check Point 7 mentioned in this link:

http://help.sap.com/saphelp_nwpi71/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm

The value that needs to be put in the action attribute for each action performed is given there.

And yes for SELECT also we have to enter the value into the action attribute.

Regards,

Abhishek.

[jyothi_anagani · Accepted solution]

For More help Refer These....

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

See this wiki for creating the structure...

It will really help you...

https://wiki.sdn.sap.com/wiki/display/stage/receiver%20JDBC%20strucutres%20creation

Thanks.

[former_member187339]

Hello Radhika,

>>In JDBC adapter, when we use mapping do we have to always map the attribute, action ? Or is it to be mapped only during INSERT.

Yes action has to be mapped always. Check this lionk for the different formats

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

>> Do we have to map access tag also always ? Access block won't be there in DELETE. So how do we map ACCESS in the Data Type ? And also is ACCESS always 1: unbounded ?

Access is not a mandatory one. Check the above url it tells clearly about the use of access and action in various statements.

>>Do we have to map the condition in WHERE Clause specified in the Update SQL Statement under Processing Parameters of JDBC Adapter ?

Same check the above url. Your doubts will be solved

Regards

Suraj

[jyothi_anagani]

Hi Radhika,

In JDBC adapter, when we use mapping do we have to always map the attribute, action ?

Yes you have map the access attribute....Then only System will generate the query according to that...

Or is it to be mapped only during INSERT

No.

Do we have to map access tag also always ?

It depends....This tag will be there for Update,insert only...It will not be there for Delete..According to that you have to design the target Structure..

Access block won't be there in DELETE. So how do we map ACCESS in the Data Type ?

Target structure you will generate na...So not required to map...

Do we have to map the condition in WHERE Clause specified in the Update SQL Statement under Processing Parameters of JDBC Adapter ?

For where clause you can use key element...Whatever you specified in key those will come under Where clause....

Thanks.