Can anyone help me to change this Oracle statement to DB2 ?

The statement is

Select * from TableA where (ColA, ColB) IN (('Result1A','Resutl1B'),('Result2A','Result2B'));

thanks for help !!

try that :

SELECT * FROM SCHEMA.TableA
WHERE (ColA, ColB) = ('Result1A','Resutl1B') OR (ColA, ColB) = ('Result2A','Result2B') OR ...etc.

Thanks, but is that DB2 cannot use the syntax " IN (('Result1A','Resutl1B'),('Result2A','Result2B')) " ?

It was because I use program to call this statement with Oracle enironment and "(('Result1A','Resutl1B'),('Result2A','Result2B')) " is put in the string, that mean
a function do this:
string_result = (dynamic get the result set e.g "('Result1A','Resutl1B'),('Result2A','Result2B ') ( ...).......or many many")

and then call this statement
Select * from TableA where (ColA, ColB) IN (string_result);

It is difficult to extract each set of result and put in the statement with "OR".

But I need to convert this function with DB2 environment.

ok! that's right :

SELECT * FROM SCHEMA.TableA
WHERE (ColA, ColB) IN (values ('Result1A','Resutl1B'),('Result2A','Result2B'))

Many many thanks !! That works ! But why I can't find in any document?

thanks you for interest question!!!

there are not direct reference to that construction, but

predicate <IN> may refer to query and query may be emulated by <VALUES> construction

oh...i c....thanks again for reply my stupid question