JDBC scenario Key field logic for Select * WHERE ((col1<>u0092au0092 AND col1<>u0092b')

[Former Member]

hi all,

In JDBC Select I wants to select where colume 1 in JDBC not contail a & b include key field as follow

SELECT col1,col2,col3 FROM dbTableName WHERE ((col1<>’a’ AND col1<>’b').

i.e. in terms of XML

<key>

<col1 compareOperation="NEQ">a</col1>

<col1 compareOperation="NEQ">b</col1>

</key>

<b>Problem is that in IR data type i can not add col1 two times.</b>

Please suggest some solution.

Regards

[Former Member]

closed

[moorthy]

HI,

Why do u need to create 2 times in the data type under key section ?

If you want to have 2 keys, then create field like col1,col2...

Just go thru this doc -http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

moorthy

[Former Member]

Hi Krishna,

Thanks for reply.

<i>

>>then create field like col1,col2...</i>

But Krishna, I want this condition on same column of JDBC, so I can’t name it col1, col2.

Regards

[bhavesh_kantilal]

Rohan,

You can handle this in mapping.

Make the occurence of COL1 as 1 to unbounded and then in your mapping duplicate the Target Subtree and map it to the corresponding values.

This will solve the issue

Regards,

Bhavesh