Looks like the generated SQL is structurally alright except that uses SUBSTRING instead of SUBSTR. If that is the case, the following configuration in persistence.xml should address the problem:
<property name="openjpa.jdbc.DBDictionary" value="informix(substringFunctionName='SUBSTR')"/> -- View this message in context: http://www.nabble.com/Informix-subselect-tp18090628p18093406.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
