title: I cannot see the Tables in my database Informix with NetBeans and I cannot do all SQL statement
body: <p>I can't see the Tables in my Informix database with NetBeans and I can't do some query with Left, Right, inner... join What can I do?</p>
  
  <p><img src="https://i.stack.imgur.com/SZNTV.jpg" alt="enter image description here"></p>
  
  <p>My LOG File looks like this. I can create or drop Tables but cannot do  Join statements.</p>
  
  <pre><code>DriverManager.getConnection("jdbc:informix-    sqli://192.168.1.10:1521//usr/projects/dbs/f0001:INFORMIXSERVER=informixse;user=Odbc;password=        odbc;APPENDISAM=1;IFX_SET_FLOAT_AS_SMFLOAT=1;TRUSTED_CONTEXT=1;IFX_ISOLATION_LEVEL=8U;ssl    Connection=1;SQLIDEBUG=c:\Temp\sqlidebug_informix.trace")
      trying com.informix.jdbc.IfxDriver
  SQLWarning: reason(Umwandlung von Datentyp FLOAT in DECIMAL verwendet)     SQLState(01I05)
  getConnection returning com.informix.jdbc.IfxDriver
  SQLState(42000) vendor code(-201)
  java.sql.SQLSyntaxErrorException: A syntax error has occurred.
      at com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:465)
      at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443)
      at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394)
      at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3191)
      at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3472)
      at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2379)
      at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2304)
      at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1522)
      at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1502)
      at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:218)
      at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1054)
      at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:227)
      at Drivers.InformixConnection.GetConnection(InformixConnection.java:57)
      at Views.User.Login.formWindowOpened(Login.java:413)
      at Views.User.Login.access$100(Login.java:44)
      at Views.User.Login$1.windowOpened(Login.java:117)
      at java.awt.Window.processWindowEvent(Window.java:2051)
      at javax.swing.JFrame.processWindowEvent(JFrame.java:305)
      at java.awt.Window.processEvent(Window.java:2013)
      at java.awt.Component.dispatchEventImpl(Component.java:4889)
      at java.awt.Container.dispatchEventImpl(Container.java:2294)
      at java.awt.Window.dispatchEventImpl(Window.java:2746)
      at java.awt.Component.dispatchEvent(Component.java:4711)
      at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
      at java.awt.EventQueue.access$500(EventQueue.java:97)
      at java.awt.EventQueue$3.run(EventQueue.java:709)
      at java.awt.EventQueue$3.run(EventQueue.java:703)
      at java.security.AccessController.doPrivileged(Native Method)
      at     java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionD    omain.java:76)
      at     java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionD    omain.java:86)
      at java.awt.EventQueue$4.run(EventQueue.java:731)    
      at java.awt.EventQueue$4.run(EventQueue.java:729)
      at java.security.AccessController.doPrivileged(Native Method)
      at     java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionD    omain.java:76)
      at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
      at     java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
      at     java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
      at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
  SQLState(00000) vendor code(0)
  java.sql.SQLException
  at com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474)
  at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443)
  at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394)
  at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3477)
  at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2379)
  at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2304)
  at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1522)
  at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1502)
  at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:218)
  at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1054)
  at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:227)
  at Drivers.InformixConnection.GetConnection(InformixConnection.java:57)
  at Views.User.Login.formWindowOpened(Login.java:413)
  at Views.User.Login.access$100(Login.java:44)
  at Views.User.Login$1.windowOpened(Login.java:117)
  at java.awt.Window.processWindowEvent(Window.java:2051)
  at javax.swing.JFrame.processWindowEvent(JFrame.java:305)
  at java.awt.Window.processEvent(Window.java:2013)
  at java.awt.Component.dispatchEventImpl(Component.java:4889)
  at java.awt.Container.dispatchEventImpl(Container.java:2294)
  at java.awt.Window.dispatchEventImpl(Window.java:2746)
  at java.awt.Component.dispatchEvent(Component.java:4711)
  at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
  at java.awt.EventQueue.access$500(EventQueue.java:97)
  at java.awt.EventQueue$3.run(EventQueue.java:709)
  at java.awt.EventQueue$3.run(EventQueue.java:703)
  at java.security.AccessController.doPrivileged(Native Method)
  at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
  at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
  at java.awt.EventQueue$4.run(EventQueue.java:731)
  at java.awt.EventQueue$4.run(EventQueue.java:729)
  at java.security.AccessController.doPrivileged(Native Method)
  at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
  at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
  at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
  at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
  at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
  at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
  at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
  at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
  registerDriver: com.informix.jdbc.IfxDriver@4ffc81de
  </code></pre>