Hi Folks, In the Informix dictionary, there's a line:
catalogSeparator = ":"; with a comment saying that Informix uses colon as the catalog separator. This causes JPA to produce statements like this: CREATE TABLE myschema:mytable (a int); This does not work with Informix IDS 10 because in IDS, the schema qualifier separator is not any different from the default, which is "." . The correct IDS syntax is CREATE TABLE myschema.mytable (a int); Colons are used in Informix, but only to qualify schemas with databases, e.g. CREATE TABLE mydatabase:myschema.mytable (a int); Even so, in IDS, I cannot reference a table created under a different database from the current connection if either database is logged. Would anyone know why the catalogSeparator was set to ":" in the Informix dictionary ? Colon is NOT the separator between the schema and table in the fully qualified name for IDS (or XPS). Thanks, Dinkar -- View this message in context: http://www.nabble.com/Colon-used-for-table%27s-scheme-qualification-in-Informix-tp16995080p16995080.html Sent from the OpenJPA Developers mailing list archive at Nabble.com.
