Subject Re: [IBO] IB_WISQL Datapump
Author Jason Wharton
> 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
> columns.
> If I look at ItemActions and click prepare then all the included
> columns have ColumnName=DIRECT and the excluded have ColumnName=BASE:
> 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 simply means that it wasn't possible for the source or destination
buffer pointers to be swapped over to the other's buffer so that there is no
need to move the data from one to the other.

IOW. If they are all direct is all that is necessary to do is call the API
to fetch, then execute, fetch then execute and so on. No need to fetch, move
data to dest, then execute. This makes it as fast as is absolutely possible.

Base just means it has to move the data...

Jason Wharton
CPS - Mesa AZ