1 Reply Latest reply on Oct 30, 2003 8:20 AM by lybo

    SQL functions

    sbello Newbie

      I'm working with Jboss and Informix. 7.30 DB. I have a problem: when I try to execute a query through JDBC, I can't use functions like trim(), or upper(). It's strange, since this DB supports those functions, I have tested it using dbaccess. The messages I get using Jboss are like this: "java.sql.SQLException: Routine (upper) can not be resolved". Could anybody help me?

      Thanks a lot