Parent topic: Data manipulation
SQL adaptation guide For Genero db 3.6x, 3.8x / Data manipulation

Temporary tables

Informix® supports temporary tables with the following statements:

SELECT ... INTO TEMP tmpname [WITH NO LOG]
CREATE TEMP TABLE tmpname ( ... ) [WITH NO LOG]

Genero db supports the same temporary table SQL instructions as Informix. However, there are some restrictions with Genero db temporary tables:

  1. Genero db does not support DDL statements inside transaction blocks.
  2. Genero db does not support the WITH NO LOG clause.
  3. Genero db does not support CREATE UNIQUE INDEX on temporary tables.

Solution

You do not need to modify your code, as long as CREATE TEMP TABLE or SELECT INTO TEMP statements do not use any of the restrictions listed.

Parent topic: Data manipulation