yeah r937 is correct. we have a combination search and we cannot split the parenthesis.
my problem is i am using a for loop which populates the right hand side of the IN Clause, and that loop is common for all database servers. (Oracle and DB2). If i dont get an similar syntax in informix for the query,i have to write a separate logic for this DB and it will create redundant code. I dont know whether informix supports this, but lets wait some more time
I'm not familiar with Oracle or DB2 syntax & I've never seen Informix use syntax like (RTS_ID,RTS_LINE_ITEM_ID) in ((-1,-1),(-2,3),(4,5)) where the value of the 1st position (RTS_ID) is compared only to the 1st value in the 3 pairs of values (-1, -2, 5) and so on.