Some times when we process string output from different other sources we will end up having invisible blank or new line or some tabbed characters which will annoy us from parsing that string for a particular thing. In that case while using Java we can use Trim method which helps a lot on this situation.

Another great quality of this trim method is , it can remove blank like characters from both sides of strings .
This method removes the blank spaces from both ends of the given string (Front and End).

A Simple example below might be helpful to use this
import java.lang.*;

public class StringTrim{
  public static void main(String[] args) {
  System.out.println("String trim example!");
  String str = " [RoseIndia, hi, hello]   ";
  System.out.println("Given String :" + str);
  System.out.println("After trim :" +str.trim());
  }
}

OutPut :
Given String : [RoseIndia, hi, hello]   
After trim :[RoseIndia, hi, hello]

Below is a simple example of java method which will return true if given database contains any table by name DB_VERSION. Else it returns false.

 /*
     * isRegistryDBConfigured()    method returns true if provided Database
     * contains table DB_VERSION. Returns false if it doesn't contain
     * that table.
     */
    public boolean isRegistryDBConfigured(String dbName, String portNumber,String userName, String password) {
        try {
          String hostName = InetAddress.getLocalHost().getCanonicalHostName();
            Class.forName("com.ibm.db2.jcc.DB2Driver");
            StringBuffer dbConnectionURL = new StringBuffer("jdbc:db2://");
            dbConnectionURL.append(hostName + ":" + portNumber + "/" + dbName);
            Connection db2Conn = DriverManager.getConnection(
                    dbConnectionURL.toString(), userName, password);
//Connection db2Conn = DriverManager.getConnection("jdbc:db2j:net://localhost:50000/frsdb","db2admin","db2admin");          
 // Connection db2Conn =  DriverManager.getConnection("jdbc:db2://localhost:50000/test","db2admin","db2admin");
            Statement st = db2Conn.createStatement();
            String myQuery = "SELECT TABNAME FROM SYSCAT.TABLES WHERE TABNAME ='DB_VERSION'";
            ResultSet resultSet = st.executeQuery(myQuery);
            while (resultSet.next()) {
                String name = resultSet.getString("TABNAME");
                if (name.equals("DB_VERSION")) {
                    System.out.println("Tablename:" + name);
                    return true;
                }
            }
            resultSet.close();
            st.close();
            db2Conn.close();
           
        } catch (Exception e) {
            System.out.println("EXCEPTION::" + e);
        }
        return false;
    }

Here is a simple DB2 - SQL  command to find a particular table name exists in given database name.


Example :
Database name : FRSDB
Table Name : DB_VERSION


C:\Users\ADMIN>db2 connect to frsdb

   Database Connection Information

 Database server        = DB2/NT64 10.1.0
 SQL authorization ID   = KRISHNA
 Local database alias   = FRSDB


C:\Users\ADMIN>db2 SELECT TABNAME FROM SYSCAT.TABLES WHERE TABNAME ='DB_VERSION'

TABNAME
--------------------------------------------------------------------------------------------------------------------------------
DB_VERSION

  1 record(s) selected.


C:\Users\ADMIN>