The following code works ok...
Thanks to all those who responded especially John, Jeff, Bruce, Charles,
Ben, and Mike.
--Bill
import java.sql.*;
public class Uni_101 {
public static void main(String[] args) {
try {
try {
Class.forName("com.ibm.u2.jdbc.UniJDBCDriver");
}
catch(Exception x){
System.out.println( "Here " + x );
}
String url
= "jdbc:ibm-u2://192.168.0.102/SHIPPING";
String userid
= "ups";
String
passWord = "brown";
Connection con = DriverManager.getConnection(url, userid,
passWord);
Statement stmt = con.createStatement();
String sql = "select @ID, NAME,
CITY, STATE from PACKSLIPS.X";
ResultSet rs = stmt.executeQuery(sql);
int i = 1;
while (rs.next() && i < 6)
{
System.out.println("\nRecord "+ i +" :");
System.out.println("\...@id : \t" + rs.getString(1));
System.out.println("\tNAME :\t" + rs.getString(2));
System.out.println("\tCITY :\t" + rs.getString(3));
System.out.println("\tSTATE :\t" + rs.getString(4));
i++;
}
rs.close();
stmt.close() ;
System.out.println("\n\t*--- QUERY test is done successful
---*\n");
}
catch (SQLException e ) {
System.out.println(e);
}
}
}
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
