topic Re: Execute file.sql script on firebird data base in Talend Studio

Execute file.sql script on firebird data base

_AnonymousUser — Thu, 27 Dec 2012 15:25:33 GMT

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?

Re: Execute file.sql script on firebird data base

Anonymous — Fri, 28 Dec 2012 01:15:35 GMT

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

Re: Execute file.sql script on firebird data base

Anonymous — Fri, 28 Dec 2012 02:06:18 GMT

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

Re: Execute file.sql script on firebird data base

Anonymous — Fri, 28 Dec 2012 13:25:32 GMT

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