A few minor errors appear to exist in the tables-informix.sql file, which cause Informix to through errors when attempting to execute the SQL as a script, using Informix's "dbaccess" application against the database version 10.0.

Please see the following diff output, which shows the difference between the SQL provided in quartz release 1.5.2, and the SQL that has been modified to cleanly execute.

--------- cut here ----
1,6c1,6
< ##
< ## Thanks to Keith Chew for submitting this.
< ##
< ## use the StdJDBCDelegate with Informix.
< ##
< ## note that Informix has a 18 cahracter limit on the table name, so the prefix had to be shortened to "q" instread of "qrtz_"
---
> { }
> { Thanks to Keith Chew for submitting this. }
> { }
> { use the StdJDBCDelegate with Informix. }
> { }
> { note that Informix has a 18 character limit on the table name, so the prefix had to be shortened to "q" instread of "qrtz_" }
61,62c61
< TRIGGER_GROUP VARCHAR2(80) NOT NULL,
< );
---
> TRIGGER_GROUP varchar(80) NOT NULL);
80,81c79
< LOCK_NAME varchar(40) NOT NULL,
< );
---
> LOCK_NAME varchar(40) NOT NULL );
160c158
< MISFIRE_INSTR numeric(2)
---
> MISFIRE_INSTR numeric(2),

--------- cut here ----

I hope this helps, and keep up the good work!