Subject | Unable to create external files from both ISQL and IB_WISQL |
---|---|
Author | peterson77 |
Post date | 2002-04-03T20:36:46Z |
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);
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);