src/main/java/org/vanilladb/bench/server/procedure/tpce/TradeOrderProc.java
private void frame1() {
		// SELECT acct_name = ca_name, broker_id = ca_b_id, 
		// cust_id = ca_c_id, tax_status = ca_tax_st FROM
		// customer_account WHERE ca_id = acct_id
		String sql = "SELECT ca_name, ca_b_id, ca_c_id, ca_tax_st FROM customer_account"
				+ " WHERE ca_id = " + paramHelper.getAcctId();
		Scan s = executeQuery(sql);
		acctName = (String) s.getVal("ca_name").asJavaVal();
		brokerId = (Long) s.getVal("ca_b_id").asJavaVal();
		custId = (Long) s.getVal("ca_c_id").asJavaVal();
		taxStatus = (Integer) s.getVal("ca_tax_st").asJavaVal();
		
		// TODO: Add this
		// num_found = row_count
		
		// SELECT cust_f_name = c_f_name, cust_l_name = c_l_name, 
		// cust_tier = c_tier, tax_id = c_tax_id FROM
		// customer WHERE c_id = cust_id
		sql = "SELECT c_f_name, c_l_name, c_tier, c_tax_id FROM customer"
				+ " WHERE c_id = " + custId;
		s = executeQuery(sql);
		custFName = (String) s.getVal("c_f_name").asJavaVal();
		custLName = (String) s.getVal("c_l_name").asJavaVal();
		custTier = (Integer) s.getVal("c_tier").asJavaVal();
		taxId = (String) s.getVal("c_tax_id").asJavaVal();
		
		// SELECT broker_name = b_name FROM broker WHERE b_id = broker_id
		sql = "SELECT b_name FROM broker WHERE b_id = " + brokerId;
		s = executeQuery(sql);
		brokerName = (String) s.getVal("b_name").asJavaVal();
	}
private void frame1() {
		// SELECT acct_name = ca_name, broker_id = ca_b_id, 
		// cust_id = ca_c_id, tax_status = ca_tax_st FROM
		// customer_account WHERE ca_id = acct_id
		String sql = "SELECT ca_name, ca_b_id, ca_c_id, ca_tax_st FROM customer_account"
				+ " WHERE ca_id = " + paramHelper.getAcctId();
		Scan s = executeQuery(sql);
		acctName = (String) s.getVal("ca_name").asJavaVal();
		brokerId = (Long) s.getVal("ca_b_id").asJavaVal();
		custId = (Long) s.getVal("ca_c_id").asJavaVal();
		taxStatus = (Integer) s.getVal("ca_tax_st").asJavaVal();
		
		// TODO: Add this
		// num_found = row_count
		
		// SELECT cust_f_name = c_f_name, cust_l_name = c_l_name, 
		// cust_tier = c_tier, tax_id = c_tax_id FROM
		// customer WHERE c_id = cust_id
		sql = "SELECT c_f_name, c_l_name, c_tier, c_tax_id FROM customer"
				+ " WHERE c_id = " + custId;
		s = executeQuery(sql);
		custFName = (String) s.getVal("c_f_name").asJavaVal();
		custLName = (String) s.getVal("c_l_name").asJavaVal();
		custTier = (Integer) s.getVal("c_tier").asJavaVal();
		taxId = (String) s.getVal("c_tax_id").asJavaVal();
		
		// SELECT broker_name = b_name FROM broker WHERE b_id = broker_id
		sql = "SELECT b_name FROM broker WHERE b_id = " + brokerId;
		s = executeQuery(sql);
		brokerName = (String) s.getVal("b_name").asJavaVal();
	}
Get customer, customer account, and broker information