Subject Re: [ib-support] Pdox2IB Metadata and Data Pump problems
Author Stevio
> >If I try to do a table that requires a domain to be created in the Domains
> >and Generators box then I get an error at the Execute script stage from the
> >separate window that comes up. The confirm box comes up saying there is an
> >ISC Error. Specified domain or source column does not exist.
> >STATEMENT:
> >TIB_DSQL: "IB_Script."
> >
> As the notes say repeatedly, this app is highly dependent on doing things in the right order. I'd like to
> be able to say this is a robust, bomb-proof, stateless app but it certainly isn't. If you read the notes,
> you will see that you have to add the CREATE DOMAIN statements to the Generators and Domains
> window yourself.

No, the notes say that this is only the case if you typed in a domain name that was not in the list. When I click Add to Script for the tables, the CREATE DOMAIN statements appear in the Domains and Generators window.

When I go to the script window the first part of the script is the following (after the initial comments):
/**************/
/* Generators */
/**************/

CREATE DOMAIN D_BOOLEAN CHAR(1);
CREATE DOMAIN D_CURRENCY DECIMAL(12,3);
COMMIT;

When I click on Execute I get an error.

Can you help?
Thanks,
Stephen


[Non-text portions of this message have been removed]