try creating an empty file d:\pharma\log_file.txt before issuing the create
table

Ernesto Cullen

----- Original Message -----
From: "Ben Johnson" <ben_johns@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, April 21, 2003 12:09 AM
Subject: [ib-support] Accessing external files


> Hi,
>
> How do we access external files in FB 1.5 ?
>
>
> CREATE TABLE E_LOG_FILE EXTERNAL 'D:\PHARMA\LOG_FILE.TXT' (
> ENTRY_DATE CHAR(10) CHARACTER SET NONE,
> ENTERED CHAR(13) CHARACTER SET NONE,
> ID CHAR(8) CHARACTER SET NONE,
> CONTROL_NO CHAR(10) CHARACTER SET NONE,
> PRODUCT_ID CHAR(5) CHARACTER SET NONE,
> QUANTITY CHAR(5) CHARACTER SET NONE,
> DESCRIPTION CHAR(50) CHARACTER SET NONE,
> NEWLINE CHAR(2) CHARACTER SET NONE
> );
>
>
> A file created with above given statment gives the following
> error
> when accessing ?
>
>
> Unsuccessful execution caused by a system error that precludes
> successful execution of subsequent statements.
> I/O error for file "D:\PHARMA\LOG_FILE.TXT".
> Error while trying to open file.
> The operation completed successfully.
> .
>
>
> Pls help
>
> Thank you.
>
> Ben
>
>
>
>
>
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>