Can we pass entire sql statements to the ibatis framework?

[Abeyratne, Sam]

I have statement that looks like   Select * from [EMAIL PROTECTED]   UNION ALL   Select * from [EMAIL PROTECTED]   UNION ALL   Select * from [EMAIL PROTECTED]   . . .     I tried to use a sqlmap that states:   <iterate conjuction=”UNION ALL”> Select * from [EMAIL PROTECTED] </iterate>   Passing a list containing [database1, databaee2, database3, etc] and this doesn’t seem to work. As I understand this is not possible in the current ibatis version.   If this is the case, I was wondering if I could make this change in java and pass the updated sql to the ibatis framework. Is this possible? How would I pass an entire sql statement?   Thanks much! Sam