Page Comparison

Old:
select distinct
'IR',
case when not exists (select * FROM dwhs_ods..ca_chart_t a  where a.fin_coa_cd= 'IR' 
                       AND a.FIN_COA_ACTIVE_CD <> 'N' )
then 'false'
else 'true'
end

New:
SELECT SELECT 
FIN_COA_CD, 
FIN_COA_ACTIVE_CDCD 
FROMFROM 
dwhs_ods..ca_chart_t WHERE fin_coa_cd_t 
WHERE 
FIN_COA_ACTIVE_CD <> 'N' AND 
FIN_COA_CD IN ('IR', 'MC', 'UC', 'XX', 'X', 'I');

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustomgetDWHServerPort();
 
ArrayList<ChartParameters> pl0 = new ArrayList<ChartParameters>();
ChartParameters cp01 = new ChartParameters();
cp01.setKfsChartCode("UC");
ChartParameters cp02 = new ChartParameters();
cp02.setKfsChartCode("MC");
ChartParameters cp03 = new ChartParameters();
cp03.setKfsChartCode("IR");
ChartParameters cp04 = new ChartParameters();
cp04.setKfsChartCode("XX");
ChartParameters cp05 = new ChartParameters();
cp05.setKfsChartCode("X");
ChartParameters cp06 = new ChartParameters();
cp06.setKfsChartCode("I");
pl0.add(cp01);
pl0.add(cp02);
pl0.add(cp03);
pl0.add(cp04);
pl0.add(cp05);
pl0.add(cp06);
List<ChartValidation> resultList0 = ds.isValidKFSCharts(pl0);
System.out.println("\nWSClient--isValidKFSCharts()");
for (Iterator i = resultList0.iterator(); i.hasNext();) {
	ChartValidation element = (ChartValidation)i.next();
	System.out.println("\t" + element.getKfsChartCode() + ": " + element.isValid());
}

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustomgetDWHServerPort();
ArrayList<ChartParameters> pl0 = new ArrayList<ChartParameters>();
ChartParameters cp01 = new ChartParameters();
cp01.setKfsChartCode("UC");
ChartParameters cp02 = new ChartParameters();
cp02.setKfsChartCode("MC");
ChartParameters cp03 = new ChartParameters();
cp03.setKfsChartCode("IR");
ChartParameters cp04 = new ChartParameters();
cp04.setKfsChartCode("XX");
ChartParameters cp05 = new ChartParameters();
cp05.setKfsChartCode("X");
ChartParameters cp06 = new ChartParameters();
cp06.setKfsChartCode("I");
pl0.add(cp01);
pl0.add(cp02);
pl0.add(cp03);
pl0.add(cp04);
pl0.add(cp05);
pl0.add(cp06);

List<ChartDetails> resultList1 = ds.getValidKFSCharts(pl0);
System.out.println("\nWSClient--getValidKFSCharts()");
for (Iterator i = resultList1.iterator(); i.hasNext();) {
	ChartDetails element = (ChartDetails) i.next();
	System.out.println("\t" + element.getKfsChartCode() + ": " + element.getKfsChartDescription());
}

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustomgetDWHServerPort();
 
List<ChartDetails> resultList1 = ds.getAllKFSCharts();
for (Iterator i = resultList1.iterator(); i.hasNext();) {
	ChartDetails element = (ChartDetails)i.next();
	System.out.println("\t" + element.getKfsChartCode() + ": " + element.getKfsChartDescription());
}