Subject Importing from external file
Author Kevin Willford
I am trying to import data from a fixed length file using the following



CREATE TABLE EXT_TBL EXTERNAL TABLE 'C:\filename.txt' TABLE COLUMNS



I get the following error when I try to commit



Cannot commit transaction:

Unsuccessful execution caused by a system error that precludes

successful execution of subsequent statements.

Access to external file "C:\filename.txt" is denied by server
administrator.



Is there something I am missing or that I need to do differently?





**********************************************************************
This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed. If you have received this email
in error please notify the system manager.

This footnote also confirms that this email message has been
swept by MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************



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