Subject Re: Using the Data Pump
Author ra8009
But when I double click and type my SQL into the component, then click
OK and reopen the component, the SQL is gone. Shouldn't it still be there?

--- In, Helen Borrie <helebor@t...> wrote:
> At 04:41 AM 6/03/2004 +0000, you wrote:
> >The data pump appears straight forward. Double click and fill in the
> >statements for the source and destination. However, when I do this the
> >statements don't persist. What might I be missing?
> Prepare? (both statements)
> You have two databases, two statements one transaction.
> Source database:
> Statement: select.................
> prepare
> Destination
> Insert...... (or execute statement if it's a SP)
> check mappings
> possibly massage
> prepare
> Transaction: commit
> Helen