topic Re: [resolved] Context variable in SQL syntax in Talend Studio

[resolved] Context variable in SQL syntax

Anonymous — Wed, 23 Apr 2014 16:08:04 GMT

Hello.
Could anyone help me run the following SQL instruction please?
"SELECT *
FROM " + context.current_TABLE "

Context variable "current_TABLE" is defined in the parent job.
Which is the error in my SQL syntax ?
Thank you very much.

Re: [resolved] Context variable in SQL syntax

Anonymous — Wed, 23 Apr 2014 19:07:49 GMT

You just seem to have an extra double-quote - context.current_TABLE "
I'd recommend not using "*" and naming your fields. It will have some heartache later.

Re: [resolved] Context variable in SQL syntax

willm1 — Wed, 23 Apr 2014 21:47:07 GMT

diarux - and make sure you're passing your context variables from the Parent to the child by checking the checkbox on the tRunJob component (transmit whole context). Other than that, should be "SELECT * FROM " + context.current_TABLE

Re: [resolved] Context variable in SQL syntax

Anonymous — Thu, 24 Apr 2014 13:35:40 GMT

Hello.
Even if I use the following syntax, I still have an error :
"SELECT * FROM " + context.current_TABLE
I passed my context variable from the Parent to the child.
Context variable "current_TABLE" is defined as follows :
((String)globalMap.get("row1.nom_table"))
I don't understand why it doesn't work.

Re: [resolved] Context variable in SQL syntax

Anonymous — Thu, 24 Apr 2014 14:25:42 GMT

You haven't actually said what the error is...

Re: [resolved] Context variable in SQL syntax

Anonymous — Thu, 24 Apr 2014 14:33:03 GMT

Hi diarux,
Use the fallowing syntax for using context variables in sql.
"SELECT * FROM \""+context.current_TABLE+"\"".
Make sure that you have to enable transmit whole context check box in setting of tRunJob in parent job.

Regards,
Bhanu.

Re: [resolved] Context variable in SQL syntax

Anonymous — Fri, 25 Apr 2014 04:47:24 GMT

Hi diarux,
Please upload your current job screenshots into forum so that we can see if there is wrong setting in your work flow.
Best regards
Sabrina

Re: [resolved] Context variable in SQL syntax

Anonymous — Mon, 28 Apr 2014 15:11:06 GMT

Hello.
Could you please take a look at the attached screenshot ?
Thank you for your help.

Re: [resolved] Context variable in SQL syntax

Anonymous — Mon, 28 Apr 2014 15:58:21 GMT

hi all,
no screenshoot available (be sure about max size)
check the value passed by 'father job' to be sure it's not null
read some help from Talend :
https://help.talend.com/search/all?query=Passing+a+value+from+a+parent+Job+to+a+child+Job&content-lang=en
regards
laurent

Re: [resolved] Context variable in SQL syntax

Anonymous — Mon, 28 Apr 2014 17:44:09 GMT

current_TABLE is defined in parent job as :
(String)globalMap.get("my-Table.nom_table")
num_utilisateur is defined in parent job as:
Integer.parseInt(jobName.substring(1,2))
Error message when running child job :
Exception in component tMSSqlInput_1
java.sql.SQLException: Syntaxe incorrecte vers 'FROM'

Still doesn't work.

Re: [resolved] Context variable in SQL syntax

Anonymous — Mon, 28 Apr 2014 18:11:14 GMT

It must be a simple error.
Add a tContextDump just before your SQL call to check the values are set as you expect.