Subject Re: [IBO] IB_WISQL Datapump
Author Helen Borrie
At 11:41 AM 30-12-00 +0000, you wrote:
>I have just been trying the datapump facility for the first time and
>have had mixed success.
>With very simple src SQL like 'select * from table where field=value'
>and dst SQL 'select * from table' it seems to be missing out some

src should be a SELECT, dst should be an INSERT.

Also, use explicit column lists in both the src and dst statements.

>If I look at ItemActions and click prepare then all the included
>columns have ColumnName=DIRECT and the excluded have ColumnName=BASE:

What makes you think they are excluded? The ones which IBO can't convert
are marked =UNASSIGNED or =SKIPPED

>What does BASE: mean? Why is it there? Is it what causes the column
>to be excluded? Is the SQL is the right form?

Base: means that there won't be (can't be) any conversion on the
data. Those columns would be blobs.

The Insert statement in the dst will fix it.


All for Open and Open for All
InterBase Developer Initiative ยท