Steffan,

I used external files on Netware some years ago and never found them
terribly reliable. Mostly they would work, but occasionally they would
be one char out of step. I think I resolved it by always re-defining the
external tables before use, and dropping the external definition after
use.

However, in your case, you are right. The external table MUST sit on the
Netware server, and you need to define it so that netware can see it:

CREATE TABLE XX EXTERNAL FILE 'VOL1:\dir\file.txt'.....

Regards

Vince

Steffen Nyeland wrote:

>
> I wrote a small program which reads a DDL-type file, replaces the "external
> file name" and creates the EXTERNAL TABLE, for import purpose.
>
> When I do this on my IB 5.x on WIN and (Linux, I think) it works, and I
> when I do a select from the table, I get my records. But when I switch to
> one of our IB 4.0 for NetWare 3.12 (Y2K OK), everything runs without
> errors, but my select returns no records.
>
> I tried to change my EOL field from 2 to1 to 3 CHARs. Without any change.
>
> I got this little idea, that it might have something todo with where I
> place my external file, and how I refer to it, because Netware might not be
> able to resolve back to my C:\TEST.TXT file, and what if another use tries
> to select from this table, it would be empty for her/him right?
>
> thanx in advance
>
> Steffen Nyeland
>
> ------------------------------------------------------------------------
> SALESFORCE.COM MAKES SOFTWARE OBSOLETE
> Secure, online sales force automation with 5 users FREE for 1 year!
> http://click.egroups.com/1/2658/5/_/679568/_/961682352/
> ------------------------------------------------------------------------
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI

--
Vince Duggan
Synectics Software
Inprise C/S Business Partner
South Africa
http://www.synectics.co.za
mailto:vince@...