Executing a script using ISQL

Question

I'm creating a simple isql script but it's not working and I need some help to find out whats wrong with it.
I need to connect to a database and execute a SQL file. This is my script called script.sql:

CONNECT 'localhost:C:\Monde\Servidor\db\monde.fdb' USER 'SYSDBA' PASSWORD 'masterkey';    
update usuario  
set senha = 'MYkWEn0kHLHHdm'  
where login = 'rose'

When I try to connect to my database using.:

isql.exe -i script.sql

I get this follow message.:

Use CONNECT or CREATE DATABASE to specify a database
Expected end of statement, encountered EOF

Luis Carrasco · Accepted Answer · 2013-04-24 17:15:52Z

9

Ok although it's an old question I found out how to do it, you just need to append de -q parameter, like this:

isql.exe -q -i script.sql

Source:

iSQL Reference form Destructor.de

answered Apr 24, 2013 at 17:15

Luis Carrasco

4673 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Quassnoi · Accepted Answer · 2015-12-09 16:28:34Z

5

Append a semicolon to the end of the UPDATE statement:

CONNECT 'localhost:C:\Monde\Servidor\db\monde.fdb' USER 'SYSDBA' PASSWORD 'masterkey';
update usuario
set senha = 'MYkWEn0kHLHHdm'
where login = 'rose';

edited Dec 9, 2015 at 16:28

answered Apr 28, 2011 at 16:07

Quassnoi

427k94 gold badges628 silver badges623 bronze badges

5 Comments

user729661 Over a year ago

Use CONNECT or CREATE DATABASE to specify a database Statement failed, SQLSTATE = 42000 Dynamic SQL Error -SQL error code = -104 -Unexpected end of command - line 1, column 8 After line 1 in file usuario.sql Command error: set senha = 'MYkWEn0kHLHHdm' where login = 'rose'

Quassnoi Over a year ago

@user: put a newline after the last line.

Quassnoi Over a year ago

@user: put the cursor to the end of file, after the final semicolon, and press Enter.

Quassnoi Over a year ago

@user: can't help you then. I just reproduced this on my Firebird 1.5, it works. Please copy and paste the commands from my answer.

user729661 Over a year ago

Well, it worked. I forgot to add a comma after "update usuario". Thank you so much for your help.

Collectives™ on Stack Overflow

Executing a script using ISQL

2 Answers 2

Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related