Re: IDS-PE + Java

Christoph Borowski <borowski@uni-paderborn.de> offerred: +Hi, + +I'm using the Informix Dynamic Server Personal Edition running on +Windows98. I downloaded the Informix Client SDK, because I have +to develop a Java program with a direct access over a JDBC-Driver, +which is in the SDK-package. Reading the documentation I remarked +that for using a JDBC-driver I have to run the script java.sql, +which can be found in the directory %IFORMIXDIR%/java/lib. +But there doesn't exist a directory with the name java or the +file jdbc.sql. Therefore I started to search for jdbc.sql and +found one in the sdk-package. +But running it in the SQL-editor I get syntax-errors in the lines +starting with "create function ..." +I've never heard that Informix databases support a keyword +named "function"!!! On the other hand this script (jdbc.sql) had +been dowloaded from the official Informix homepage. CREATE FUNCTION is only supported in the Universal Data Option (UDO, formerly knownas IUS, aka Informix 9.14). I haven't used JDBC, so I cannot answer any of your other questions. My understanding was that INFORMIX-Object Interface for Java (what is included in the SDK) works against both servers (IDS & UDO). Take a look at the first page of appendix A of the manual, where it shows what classes are available with what server versions. I think as long as you are using the IDS only objects, you do not need to run jdbc.sql. Dave ** Dave Kosenko <davek@summitdata.com> ** Director of Training Services (732) 469-4070 ** Summit Data Group (an Informix Authorized Education Center) ** Find my advice useful? Let me teach you everything I know about ** Informix. Sign up for OFFICIAL Informix training at SDG. ** For details, see http://www.summitdata.com/training