not able to print DBInput_1_Query

[IamHulk]

Hi

my job flow like 

tfileinputDelimted--main-->tflowtoiterate--iterate-->tdbinput--main-->tjava

input file is txt its having schema and table name. in dbinput component im writing query like select * from schema.table;

i'm getting output as expected. but while i'm printing source query in java its printing null.  

in tjava i'm printing like system.out.println(((string)globalMap.get("tdbinput_1_query"));

[nivedhitha]

@IamHulk ,

can you provide screenshots of your jobs?

[mks02 · Accepted solution]

Hi @IamHulk ,

To print the sql query in tjava, you need to print the query on OnSubJobOK as below:

t<DB>Input -- t<DB>Output

    |    OnSubjobOk

tJava 

System.out.println("tJavaTable:TBL Loaded" + (String)globalMap.get("tMysqlInput_1_QUERY"));

Thanks.