import java.sql.*;
class mst
{
   public static void main(String[] argv)
   {
		String url = "jdbc:db2:MYBASE";
		String userid = "MYLOGIN"; // or from argv[ 0 ];
                         String passwd = "MYPWD"; //or from argv[ 1 ];

		Connection con;
		Statement stmt1;
		ResultSet rs;
		String select1 = "SELECT * FROM SomeTable FETCH FIRST 10 ROW ONLY";
		try
		{
			Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
			con = DriverManager.getConnection (url, userid, passwd);
			con.setAutoCommit(true);
			stmt1 = con.createStatement();
			rs = stmt1.executeQuery(select1);
			int iter =  1 ;
			while (rs.next()) {
				System.out.println(iter + " " + rs.getString( 1 ) 
					+ "  " + rs.getString( 2 )
					+ "  " + rs.getString( 3 )
					+ "  " + rs.getString( 4 ));
				iter++;
			}
			rs.close();
			stmt1.close();
			con.commit();
			con.close();
		}
		catch (ClassNotFoundException drvEx)
		{
			System.err.println("Could not load JDBC driver");
			System.out.println("Exception: " + drvEx);
			drvEx.printStackTrace();
		}
		catch(SQLException sqlEx)
		{
			while(sqlEx != null) {
				System.err.println("SQLException information");
				System.err.println("Error msg: " + sqlEx.getMessage());
				System.err.println("SQLSTATE: " + sqlEx.getSQLState());
				System.err.println("Error code: " + sqlEx.getErrorCode());
				sqlEx.printStackTrace();
				sqlEx=sqlEx.getNextException();
			}
		}
   }
}

set path=%PATH%;c:\jdk\bin
javac mst.java
java mst > result.txt