Execute file.sql script on firebird data base

[_AnonymousUser]

Hello.
I have sql file with several updates to do on my firebird database.
Update xpto set a=a;
Update xpto set b=b;
etc...
How can I execute this, since tfirebirdrow, does not support this feature?

[Anonymous]

You can do it like this :
"begin
execute immediate 'create statement 1';
execute immediate 'create statement 2';
commit;
end;"

[Anonymous]

Hi
You can read line one by one, and then iterate each sql statement on tFirebirdRow. For example:
tFirebirdConnection
|
onsubjobok
|
tFileInputLine--main(row1)--tFlowToIterate--iterate--tfirebirdrow
|
tFirebirdClose
on tFirebireRow, check the option 'use an existing db connection, set the query as:
row1.line
shong

[Anonymous]

Or you can use the component tSQLScriptParser from Talend Exchange which is designed to do exactly this work!