For example the following SQL creates the temp table temptab1 with no logging.
create temp table temptab1 with no log;
In IDS 11, you can control the default logging mode of temporary tables. If you set the configuration parameter TEMPTAB_NOLOG to 1, temp tables created in a logged database will be non-logging by default. This is useful inreplication environments where you create your databases logged but do not want to replicate your temp tables.
If TEMPTAB_NOLOG is set to 0, this feature is disabled.
Suma Vinod
[Read More]