How to input the entire query from file to tDBInput

[Anonymous]

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.

[TRF]

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

[Anonymous]

Getting error as Invalid SQL type: sqlKind = UNINITIALIZED

Thanks,

Meghana.

[TRF]

How Can we guess what your SQL query looks like?

[Anonymous]

I am trying with simple sql query on experiment.

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

Thanks,

Meghana.

[TRF]

And your schema is contains...

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

[Anonymous]

Here it is

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

[manodwhb]

@MeghanaKottala,can you try with below.

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

[Anonymous]

Getting compile time error saying 

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

[TRF]

Try with the following query:

select 2 Val from dual