";decimal separator=" + decChar );
";decimal separator=" + decChar + ";extended metadata=true;translate binary=true");
   public boolean connect(String host) {      connection   = null;      hostName = host.toUpperCase();      try {         printFTPInfo("Connecting to " + hostName);         Driver driver2 = (Driver)Class.forName("com.ibm.as400.access.AS400JDBCDriver").newInstance();         DriverManager.registerDriver(driver2);         // Get a connection to the database.  Since we do not         // provide a user id or password, a prompt will appear.         // modified the connection string to add the translate binary = true         //   as suggested from Luca         connection = DriverManager.getConnection ("jdbc:as400://" + hostName +                                                   ";decimal separator=" +                                                   decChar +                                                ";extended metadata=true;translate binary=true",                                                      user,pass);         printFTPInfo("jdbc:as400://" + hostName +                                                   ";decimal separator=" +                                                   decChar );         fireInfoEvent();         printFTPInfo("Connected to " + hostName);         return true;      }      catch (NoClassDefFoundError ncdf) {         printFTPInfo("Error: JDBC Driver not found.  Please check classpath." );      }      catch (Exception e) {//         JOptionPane.showMessageDialog(this,//                           "Error: " + e.getMessage() + "\n\n" +//                           "There was an error connecting to host "//                           + system.toUpperCase() +//                           "\n\nPlease make sure that you run " +//                           "the command STRHOSTSVR",//                           "Host connection error",//                           JOptionPane.ERROR_MESSAGE);         printFTPInfo("Error: " + e.getMessage() + "\n\n" +                           "There was an error connecting to host "                           + host.toUpperCase() +                           "\n\nPlease make sure that you run " +                           "the command STRHOSTSVR");         System.out.println ( "Exception while retrieving data : " + e.getMessage());      }      return false;   }