SQLJ

PreparedStatement stmt = conn.prepareStatement(
   "SELECT LASTNAME"
 + ", FIRSTNME"
 + ", SALARY"
 + " FROM DSN8710.EMP"
 + " WHERE SALARY BETWEEN ? AND ?");
stmt.setBigDecimal(1, min);
stmt.setBigDecimal(2, max);
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
  lastname = rs.getString(1);
  firstname = rs.getString(2);
  salary = rs.getBigDecimal(3);
  // Imprimir fila...
}
rs.close();
stmt.close();

#sql private static iterator EmployeeIterator(String, String, BigDecimal);

...

EmployeeIterator iter;
#sql [ctx] iter = {
  SELECT LASTNAME
      , FIRSTNME
      , SALARY
    FROM DSN8710.EMP
   WHERE SALARY BETWEEN:min AND:max
};
while (true) {
  #sql {
    FETCH:iter
     INTO:lastname,:firstname,:salary
  };
  if (iter.endFetch()) break;
  // Imprimir fila...
}
iter.close();

PreparedStatement stmt = conn.prepareStatement(
    "SELECT MAX(SALARY), AVG(SALARY)"
  + " FROM DSN8710.EMP");
rs = statement.executeQuery();
if (!rs.next()) {
  // Error -- no se encontraron filas
}
maxSalary = rs.getBigDecimal(1);
avgSalary = rs.getBigDecimal(2);
if (rs.next()) {
  // Error -- más de una fila encontrada
}
rs.close();
stmt.close();

#sql [ctx] {
  SELECT MAX(SALARY), AVG(SALARY)
    INTO:maxSalary,:avgSalary
    FROM DSN8710.EMP
};

stmt = conn.prepareStatement(
   "INSERT INTO DSN8710.EMP " +
   "(EMPNO, FIRSTNME, MIDINIT, LASTNAME, HIREDATE, SALARY) "
 + "VALUES (?, ?, ?, ?, CURRENT DATE, ?)");
stmt.setString(1, empno);
stmt.setString(2, firstname);
stmt.setString(3, midinit);
stmt.setString(4, lastname);
stmt.setBigDecimal(5, salary);
stmt.executeUpdate();
stmt.close();

#sql [ctx] {
  INSERT INTO DSN8710.EMP
    (EMPNO,  FIRSTNME,   MIDINIT,  LASTNAME,  HIREDATE,     SALARY)
  VALUES
    (:empno,:firstname,:midinit,:lastname, CURRENT DATE,:salary)
};