Read multiple sql queries in text or excel file

[BNP]

Hi ,

I want to read multiple sql queries in text or excel.file.retrieve the data from Database using tflowtoiterate can someone help me

[nivedhitha]

@BNP , sure but what is the current job design and where exactly do you need help with?

On a high level the design has to be like 

Parent Job ----  tFileExcelInput -> tFlowToIterate -> tRunJob(child job)

-Pass the query to the child job as a context variable (any any other data from the excel that the database load needs)

Child Job ----- tDbInput -> tDbOutput

Child job has context variables to hold values being passed by the parent job

[BNP]

Instead of running child job. Can we use global variables?.

[manodwhb]

@BNP , Yes you can use the global variables of tFlowtoIterate. and your job design should be like below.

tFileExcelInput -> tFlowToIterate --iterate-- tDbInput -> tDbOutput

[BNP]

Hi,

Thank you for replied.

I have save file name as SQL Statement, and i mention schema as Statement, Query.

In tDBinput table field and Query what should enter. i have attached error images. 

Ex:

(String)globalMap.get("row.ColName")

in row.colname, what should enter. 

Thank you

Capture.GIF
Capture1.GIF

[manodwhb]

Hi, you need to we the global variable in tdbinput . are queries are select staments?