unique key

[Former Member]

Hi,

while i need to update_insert a record: on oracle database side i have 5 keys which are unique keys: how do i need to create these keys out of these 2 options: first option is like aggregation of all keys ,second option is separating different keys

1) <key>

<col1>

<col2>

<col3>

<col4>

<col5>

</key>

2) < key1>

<col1>

</key1>

<key2>

<col2>

</key2>

........

[Former Member · Accepted solution]

Hi,

If you define all the 5 unique identifier under 1 single key, then it will work as AND operation.

If you define diiferent keys for every identifier, then it will work as OR operation.

-Supriya.

[Former Member]

first option is correct, these are for AND / OR operations.

[former_member200962]

how do i need to create these keys out of these 2 options:

It depends on how you want to combine the key values: http://help.sap.com/saphelp_nwpi711/helpdata/en/44/7b6d32fde93673e10000000a114a6b/content.htm

From help.sap.com:
Column values within a <key> element are combined with a logical AND; different <key> elements are combined with a logical OR.

If you want that all the key values should be met then use option 1 ....if any one of the 5 values then use option 2

Regards,

Abhishek.