This is a problem with several databases which implement a jdbc or odbc
interface.
Basically the only way to be sure and get column information is to just
"select * from table_name where 1 = 2" that will give you an empty result set
from which you can grab column names. Then email informix and sug
I've been playing around with the MetaData commands, but I keep running
into problems. When I include the following chunk of code:
DatabaseMetaData mymetadata = con.getMetaData();
ResultSet metadata = mymetadata.getColumns(null, null,
"custom", null);
I get this message
Error SQL: java.sql.SQ