if (this.conn==null) conn = getConn(); else conn = this.conn;
stmt = conn.createStatement(); // used for secondary query on SYS02...
ResultSet rset = null;
// retrieve windows customizations...
CustomizedWindows cust = new CustomizedWindows();
rset = stmt.executeQuery(
"select SYS12_WINDOW_CUSTOMIZATIONS.PROGRESSIVE_SYS13,SYS12_WINDOW_CUSTOMIZATIONS.COLUMN_NAME,"+
"SYS12_WINDOW_CUSTOMIZATIONS.COLUMN_TYPE,SYS12_WINDOW_CUSTOMIZATIONS.COLUMN_SIZE,"+
"SYS12_WINDOW_CUSTOMIZATIONS.COLUMN_DEC,SYS12_WINDOW_CUSTOMIZATIONS.PROGRESSIVE_SYS10,"+
"SYS12_WINDOW_CUSTOMIZATIONS.ATTRIBUTE_NAME,SYS10_TRANSLATIONS.DESCRIPTION,SYS13_WINDOWS.TABLE_NAME "+
"from "+
"SYS12_WINDOW_CUSTOMIZATIONS,SYS10_TRANSLATIONS,SYS13_WINDOWS where "+
"SYS13_WINDOWS.PROGRESSIVE=SYS12_WINDOW_CUSTOMIZATIONS.PROGRESSIVE_SYS13 and "+
"SYS10_TRANSLATIONS.LANGUAGE_CODE='"+langId+"' and "+
"SYS12_WINDOW_CUSTOMIZATIONS.PROGRESSIVE_SYS10=SYS10_TRANSLATIONS.PROGRESSIVE "+
"order by SYS12_WINDOW_CUSTOMIZATIONS.PROGRESSIVE_SYS13,SYS12_WINDOW_CUSTOMIZATIONS.PROGRESSIVE_SYS10"
);
WindowCustomizationVO vo = null;
while(rset.next()) {
vo = new WindowCustomizationVO();
vo.setProgressiveSys13SYS12(rset.getBigDecimal(1));
vo.setColumnNameSYS12(rset.getString(2));
vo.setColumnTypeSYS12(rset.getString(3));
vo.setColumnSizeSYS12(rset.getBigDecimal(4));
vo.setColumnDecSYS12(rset.getBigDecimal(5));
vo.setProgressiveSys10SYS12(rset.getBigDecimal(6));
vo.setAttributeNameSYS12(rset.getString(7));
vo.setDescriptionSYS10(rset.getString(8));
vo.setTableNameSYS13(rset.getString(9));
cust.addWindowCustomization(vo);
}
rset.close();
return cust;
} catch (Exception ex1) {