String url = "jdbc:db2:magic";
Connection con = 
                  DriverManager.getConnection(url,"North","mypass");
Statement stmt = con.createStatement(
   ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
stmt.setFetchSize(20);
ResultSet rs = stmt.executeQuery(
                 "SELECT surname, firstname, category FROM employees");