Helen (or anyone else that can help) :)

How does the CREATE TABLE <table> EXTERNAL handle importing of records that already exist? Do they get rejected and, if so, does that mean the entire import gets dumped?

Regards,
Dan


---- Original Message ----
OK, forget all that syntax. The nearest equivalent is
CREATE TABLE <table-name> EXTERNAL <filesystem-path-name> (see
LangRef.pdf). Your input file needs to be in fixed field format. This
allows you to query the external data file as though it were a table. You
can, for example, write a stored procedure to massage the data and store it
in any way you like.

/heLen