topic Re: [RESOLVED] Use Context variable in component SQL in Talend Studio

[RESOLVED] Use Context variable in component SQL

Roman01 — Fri, 15 Nov 2024 23:42:58 GMT

Hello Community,

I get an issue when I use the component tDBInput. I would like to use the context variable in SQL but it's not working.

I need to replace in the SQL the syntax in the clause FROM like :

SELECT

FROM

"NAV2K9R2-PROD".dbo."CK sa$Purch_ Inv_ Header"

I read on another post to use simple quote but I do not understand how it's work. I still have an error when I write like this :

SELECT

FROM

context.dbWorkflow_Database

context.dbNavision1_Schema

context.vPurchInvoice

How is it work in SQL to use context because I have the error 'Invalid object name' or '+' invalid syntax. ?

Thanks a lot,

Romain.

Re: [RESOLVED] Use Context variable in component SQL

Anonymous — Tue, 21 Sep 2021 07:25:27 GMT

Hello,

When you're running your job with log4j debug logs it will print the actual query submitted to the database. From that you could see how the parameters work. There's no variable substitution in talend. The queries are java Strings. So instead of:

"SELECT * FROM [TABLE]" you can use: "SELECT * FROM [" + context.table + "]"

And this will generate the right query.

Re: [RESOLVED] Use Context variable in component SQL

Roman01 — Tue, 21 Sep 2021 11:55:12 GMT

Thank for you reply.

But I have still the error 'Incorrect syntax near '+'' (below attachment ) It seems the SQL doesn't work with double quote or the brackets are not working ?