topic Re: How to input the entire query from file to tDBInput in Talend Studio

How to input the entire query from file to tDBInput

Anonymous — Sat, 16 Nov 2024 07:34:16 GMT

Hi,

Can we dynamically input query to tDBInput.

I mean to say, I will store list of queries in a file having same output schema.

tFileInputExcel--->row1(main)--->tFlowTolerate--->iterate-->tDBInput

So, query part of tDBInput has to take query from the iteration.

I tried putting " '" + globalMap.get("row1.SqlQuery") + "' "

Am I going wrong, anyway I got error doing this way.

Can I have some alternate solution?

Thanks in advance,

Meghana.

Re: How to input the entire query from file to tDBInput

TRF — Thu, 27 Sep 2018 08:38:39 GMT

Try to replace globalMap.get("row1.SqlQuery") by (String)globalMap.get("row1.SqlQuery")

Re: How to input the entire query from file to tDBInput

Anonymous — Thu, 27 Sep 2018 08:46:31 GMT

Getting error as Invalid SQL type: sqlKind = UNINITIALIZED

Thanks,

Meghana.

Re: How to input the entire query from file to tDBInput

TRF — Thu, 27 Sep 2018 08:50:59 GMT

How Can we guess what your SQL query looks like?

Re: How to input the entire query from file to tDBInput

Anonymous — Thu, 27 Sep 2018 08:54:40 GMT

I am trying with simple sql query on experiment.

Select 2 from dual------> This is what I have in my excel sheet.

Thanks,

Meghana.

Re: How to input the entire query from file to tDBInput

TRF — Thu, 27 Sep 2018 09:22:18 GMT

And your schema is contains...

Share as many details as you can if you want someone to help you.

Re: How to input the entire query from file to tDBInput

Anonymous — Thu, 27 Sep 2018 09:52:24 GMT

Here it is

Screen Shot 2018-09-27 at 1.55.21 PM.png

Re: How to input the entire query from file to tDBInput

manodwhb — Thu, 27 Sep 2018 10:02:06 GMT

@MeghanaKottala,can you try with below.

" (String)globalMap.get("row1.SqlQuery") "

Re: How to input the entire query from file to tDBInput

Anonymous — Thu, 27 Sep 2018 10:17:39 GMT

Getting compile time error saying

Syntax error on token "SqlQuery", AssignmentOperator expected after this token

Re: How to input the entire query from file to tDBInput

TRF — Thu, 27 Sep 2018 11:05:09 GMT

Try with the following query:

select 2 Val from dual

Re: How to input the entire query from file to tDBInput

Anonymous — Fri, 28 Sep 2018 08:21:40 GMT

It is not working.

Can u please try this.

Thanks.

Re: How to input the entire query from file to tDBInput

Anonymous — Fri, 28 Sep 2018 10:35:53 GMT

Issue solved.

The solution is

(String)globalMap.get("row2.SqlQuery")

without double quotes.

Thanks,

Meghana.