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