Link to home
Start Free TrialLog in
Avatar of cscg1976
cscg1976

asked on

Error SP2-0310 ; explain to me why it was fixed by substituting ; with / (below) the line

I was executing

-- install.sql includes
start c:\TABLES\deletetables.sql;
commit;
start c:\TABLES\createtables.sql;
commit;

So i rung install
sql>start c:\install.sql

it was giving me an  SP2-0310: unable to open file "c:\TABLES\deletetables.sql;"

Then what i did is changing the install.sql to

-- install.sql includes
start c:\TABLES\deletetables.sql
/
commit;
start c:\TABLES\createtables.sql
/
commit;


and it worked fine.

Can you please tell me why is that happening ?
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The forward slash / is a statement delimiter. it separates your start command from the commit
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial