Re: too long to 'source;

[john kay]

it gives me an error when I try that. Here is my result.

DROP TABLE IF EXISTS db2.location &&&SHOWS 0 ROWS EFFECETD, 1 WARNING 'UNKNOW TABLE LOCATION'
CREATE TABLE db2.location LIKE enswitch.location;&& SHOWS ERROR 'DB.LOCATION; DOES NOT EXIST
INSERT INTO db2.location SELECT * FROM endwitch.location;

(same error for all others as well).

The ACTUAL part of my script that is slow is this line:

Source C:/sql/bin/enswitch.sql;

that's the only line that is slow. So, what I'm trying to achieve is to 'source' only those specific 4 tables.

any help?


thanks,J