
142 DB2 II and WPS Synergy
public Query1(String url,String driver,String user,String password){
super(url,driver,user,password);
}
public Query1(String dsName){
super(dsName);
}
public void setCust_id(String c){
cust_id=c;
}
public boolean executeQuery(){
if(!cust_id.equals(""))
return super.executeQuery("SELECT DEMO.CUSTOMER_DB2.CUSTOMER_ID,
DEMO.CUSTOMER_DB2.FIRST_NAME || ' ' || DEMO.CUSTOMER_DB2.LAST_NAME,
DEMO.CUSTOMER_DB2.ADDRESS, DEMO.CUSTOMER_DB2.CITY, DEMO.CUSTOMER_DB2.STATE,
DEMO.CUSTOMER_DB2.POLICY_TYPE, DEMO.CUSTOMER_DB2.POLICY_PREMIUM,
DEMO.CLAIMS_DOMINO.ODATE, DEMO.CLAIMS_DOMINO.CDATE,
DEMO.CLAIMS_DOMINO.INCIDENT_ID, DEMO.CLAIMS_DOMINO.DO ...