Subject Unable to create external files from both ISQL and IB_WISQL
Author peterson77
I am trying to run scripts from either ISQL or IB_WISQL but am having
problems creating external files from either.

o Using IB_WISQL, if I manually connect to the database and execute
script B, I get an error, "ISC ERROR CODE: 335544569, Dynamic SQL
error; sql error code = -204; Table unknown SUBJECTPIC_EXT; At line 1
column 13"

o Using ISQL, if I execute the statements in scriptA (by typing them
directly), the isql program in the DOS window hangs and I must
control-C out of it.

Am I missing something here? What is the best way to run a script?


SCRIPT_A
-----------
CONNECT 'c:\comnet\db\ncsuced\NCSUCED1_42.GDB' USER 'PETERSON'
PASSWORD
'xxx';

CREATE TABLE SUBJECTPIC_EXT external file
'c:\comnet\db\ncsuced\subjectpic.ext'
(SUBJECT VARCHAR(60) NOT NULL);


SCRIPT_B
-----------
CREATE TABLE SUBJECTPIC_EXT external file
'c:\comnet\db\ncsuced\subjectpic.ext'
(SUBJECT VARCHAR(60) NOT NULL);