Subject | Importing from external file |
---|---|
Author | Kevin Willford |
Post date | 2004-03-05T18:32:29Z |
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]
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]