Subject PDOXPUMP
Author hwelmore2002 <hwelmore@kimbanet.com>
Helen, I've run into a different problem now. Here is whats happening
now.

1. Using IB_SQL I've created a database (dialect 3)
2. Executed IB_Domain.SQL
3. Browsed the database and the Country, IB_Domain, and IB_Domain_Map
tables are created.
4. Executed PDOXPUMP
5. Logged into database
6. On Metadata and Data Pump screen, checked Do Datapump and Dialect
3 boxes.
7. BDE login and loaded table to pump
8. Added to scrip the single primary index (field of VARCHAR(3))
9. Refreshed Domains
10. Selected each field with domain types and selected the proper
domain type in the combobox.
11. Clicked add to script for table.

At this point I get the error message 'Invalid Variant Type
Conversion'.
In the table script window is the following:

Create Table Vehicle(
Veh Varchar(3) Not Null

Out of curiosity, I clicked the Add table script again and received
the same error msg above. And now in the table script is:

Create Tabel Vehicle(
Veh Varchar(3) Not Null
P_Date D_Date Not Null

Clicking the add table script once more added to the table script the
create table vehicle( line and all fields from the pdox table.

However there was nothing in the Domains and Generators window.
Naturally I can't pump the table without the Domains being created in
the script and I forget the exact systax to use.
Anyway, can you send us a fix?

Thanks
Wayne