How to use SQL function and where to put it?

[Anonymous]

Hi everyone,
Could you tell me how to apply/use a SQL function created and saved under a sql file (file.sql) in Talend?
I am not sure if I make myself clear. I actually want to use a SQL function in tMysql_Input component. How can I do that?
Thanks before hand.

[janhess]

Why don't you just create this function in the database?

[Anonymous]

Why don't you just create this function in the database?

Can you tell me how?
Here is what I try :
Metadeta->Db Connections->DemoMysql 0.1->Queries?

[Anonymous]

I am back.
Everything works now. Thanks alot everyone, shong, mpa and janhess.

[janhess]

How did you resolve it?

[Anonymous]

I followed what mpa suggested and debugged the SQL function itself.
Copy-past the function in the SQL query section of Tmysqlrow did not work. I had to quote the whole function code, making it look like one big long string.
I am not sure if I made myself clear

[janhess]

You have to do that with all SQL in Talend

[Anonymous]

You have to do that with all SQL in Talend

Yep. Just figured that out. I am new to Talend. It's been like a week that I use it