Insert into ... select from , and logging
Posted in 2000
Neil Truby — — source: Informix-list mailing list archive (1991-1998)
IDS 9.20 (lw_coline); IDS 7.31 (coline).
The "staging" database is a "datamart" arrangement which will be refreshed
each night, and which does not therefore need to be logged. However, the
statement below will not work unless staging is logged, because londis_syn
must have logging because the database for which it contains synonyms has
it!
Is there any way around this (569 Cannot reference an external database
without logging)?
thanks
Neil
INSERT INTO staging:coline
SELECT order_nbr, customer, r_item, entered_price, unit_price,
sell_unit_prc, sell_prc_curr, unit_cost, order_qty,
shipped_qty, invoice_qty, returned_qty, spr_uom, sell_uom
FROM londis_syn:lw_coline;