[All]
How can I find the file that houses data for my external table?
By: Borland Staff
Abstract: Showing metadata will allow you to see where the external file is created.
Problem:
I used the syntax listed below to create an external table:
Create table Fred external file "deleteme.txt"
( Warehouse char(10),
Partnumber char(18),
deliverTo char(13),
EOL char(2)
)
Later in my application, I am inserting data into this file.
I am not sure how to find the file on disk that will house my data.
Solution:
Note: This information applies to InterBase 5.5
InterBase assumes that you want to write to the current working directory if you do not specify
a directory to place the external file in. You can find out where InterBase is writing your data to
by doing a show metadata on the table using either ISQL or Windows ISQL.
Here is an example creating an external table without providing a full pathname for
the external file.
*** First create the table without a full pathname ***
D:workbbandy>isql nuschler:d:workemployee.gdb
Database: nuschler:d:workemployee.gdb
SQL> create table ext_blah external file 'ext_blah.table' (i1 integer);
SQL> commit;
SQL> exit;
*** use ISQL's show table to view the full pathname for the external file ***
D:appsib6.0beta1>isql nuschler:d:workemployee.gdb
Database: nuschler:d:workemployee.gdb
SQL> show table ext_blah;
External file: C:WINNTSYSTEM32EXT_BLAH.TABLE
I1 INTEGER Nullable
Connect with Us