Skip to Content
0
Former Member
Nov 29, 2006 at 10:32 PM

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

18 Views

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