IS there a way pass an entire sql statement?

[Abeyratne, Sam]

Hi,   I Have a sql statement that needs to be plugged into an sqlmap. Basically, I want to pass the entire sql. The final sqlmap will look like this:     <select id="queryInterfaceBacklogs_DUAL" resultMap="interface_backlog_result" cacheModel="interface_backlog_cache ?sqlstatement? <select>   and the ‘statement’ will be the select statement below. Is this possible in iBatis? Can you tell me how I would go about doing this? An example would be greatly appreciated.   Many thanks! Sam                select       interface_name as SYSTEM_NAME,       sum(backlog_val) as BACKLOG_VAL,       sum(backlog_last1) as BACKLOG_LAST1,       sum(backlog_last2) as BACKLOG_LAST2,       sum(backlog_last3) as BACKLOG_LAST3       from       (         select         a.interface_name,         sum(decode(i.BACKLOG_VAL,'',0,i.BACKLOG_VAL)) as BACKLOG_VAL,         sum(decode(i.BACKLOG_LAST1,'',0,i.BACKLOG_LAST1)) as BACKLOG_LAST1,         sum(decode(i.BACKLOG_LAST2,'',0,i.BACKLOG_LAST2)) as BACKLOG_LAST2,         sum(decode(i.BACKLOG_LAST3,'',0,i.BACKLOG_LAST3)) as BACKLOG_LAST3         from [EMAIL PROTECTED] i,           ( select distinct interface_name           from [EMAIL PROTECTED]           where category='Provisioning'           )a         where SYSTEM_NAME is not null         and a.interface_name = i.system_name         group by a.interface_name               UNION ALL           select         a.interface_name,         sum(decode(i.BACKLOG_VAL,'',0,i.BACKLOG_VAL)) as BACKLOG_VAL,         sum(decode(i.BACKLOG_LAST1,'',0,i.BACKLOG_LAST1)) as BACKLOG_LAST1,         sum(decode(i.BACKLOG_LAST2,'',0,i.BACKLOG_LAST2)) as BACKLOG_LAST2,         sum(decode(i.BACKLOG_LAST3,'',0,i.BACKLOG_LAST3)) as BACKLOG_LAST3         from [EMAIL PROTECTED] i,           ( select distinct interface_name           from [EMAIL PROTECTED]           where category='Provisioning'           )a         where SYSTEM_NAME is not null         and a.interface_name = i.system_name         group by a.interface_name         )       group by interface_name