Standard join syntax can be used to join Ingres and X100 tables in SELECT, UPDATE, and DELETE statements. Such queries are referred to as hybrid queries or hybrid joins.

Hybrid queries are executed in the X100 query engine. Fragments of the query that reference Ingres tables are executed in the Ingres query engine, and the results piped into X100. Because all query results come from the X100 engine, the Ingres-only data types long varchar, long nvarchar, long byte, byte, varbyte, table_key, object_key, and the spatial data types cannot be used in a hybrid query.

The ingresdate data type can be used in a hybrid query; however, unless explicitly CAST to an ANSI datetime data type, the ingresdate values are automatically cast to ansidate for query processing. If the query returns ingresdate values, the ansidate data will be cast back to ingresdate for returning to the user. When designing tables and queries for hybrid processing, we strongly recommend avoiding ingresdate and using the appropriate ANSI datetime data type instead.

Referential constraints are not supported in hybrid queries.