Re: Insert into ... select from , and logging
Neil Truby wrote:
>
> 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;
You must maintain a separate connection to each database, as dbcopy does,
to be able to use data from mulitple databases with different logging
status.
Art S. Kagel
> > Is there any way around this (569 Cannot reference an external database > > without logging > You must maintain a separate connection to each database, as dbcopy does, > to be able to use data from mulitple databases with different logging > status. Er, does that mean "No"? There's nothing clever I can do with separate server names? thanks Neil
Neil Truby wrote: > > > > Is there any way around this (569 Cannot reference an external database > > > without logging > > > You must maintain a separate connection to each database, as dbcopy does, > > to be able to use data from mulitple databases with different logging > > status. > > Er, does that mean "No"? There's nothing clever I can do with separate > server names? Er, no. Use dbdelete & dbcopy to do the refresh. 80} <Silly Grin> Art S. Kagel