cancel
Showing results for 
Search instead for 
Did you mean: 

Value key field in XML for JDBC scenario

Former Member
0 Kudos

Hi All,

I am working on RFC to JDBC scenario.

I have one table in Oracle DB (like mara in sap).

I wants to read whole data through JDBC adapter.

I am doing following mapping:

'1' - SELECT

'SELECT' - @action

access

<tablename> - table

'' - <fields1...n>

key

???? - <key field1>

Q1) Pls suggest what value i give in key field to

select all records from DB????

Q2) Pls suggest what value i give in key field to

select records with db_field1<> ''????

Regards

Accepted Solutions (1)

Accepted Solutions (1)

MichalKrawczyk
Active Contributor
0 Kudos

hi,

did you have a look at this page?

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

it describes how to use the key field

and also how to use compareOperation for <> NEQ

Regards,

michal

Former Member
0 Kudos

Thanks for reply.

But I am not clear How/Where to add optional attributes with key element?

Or

I give key_field name as <field_name compareOperation=”NEQ”>

Pls help in that.

"The XML elements in the <key>elements can have the following optional attributes:

compareOperation= <compareType>"

Regards

Former Member
0 Kudos

Done Thanks for help

Answers (0)