Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"));
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.
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.