With a select statement that looks like this:
select i.case_number as ‘caseNumber’
, r.subject_last_name
, r.subject_first_name
, r.subject_middle_name
, r.subject_suffix
from r_report r, investigation i
,table_col tc1
where
i.case_number = r.rkey_case_number
and tc1.table_col = 102
and tc1.key_col = i.investigative_unit
and convert
(substring(convert(r.print_hold_date,char(8)),1,4) + ‘-’ +
substring(convert(r.print_hold_date,char(8)),5,2) + ‘-’ +
substring(convert(r.print_hold_date,char(8)),7,2), Date)
between convert(‘2012-06-01’,Date) and
timestampadd( SQL_TSI_DAY, convert( tc1.valu, integer), convert(‘2012-11-01’,Date))
and r.report_sid in (‘9045’,‘9046’,‘Y017’,‘D364’)
Who resolves the convert/substring function on the print_hold_date column? Is this criteria being processed by the CONNX JDBC Server or the SQL Gateway component on the mainframe?
Many thanks.