I want to store number of lines value in a variable to use in tmap

[Just_learner]

using tdboutput I'm able to store data in a table and now I want to store the number of lines inserted to a column in tmap.

After inserting the data using tdboutput I connected that with a tmap where I created a new column named inserted and in that I want to put the number of rows inserted count.

How to do that?

[Anonymous]

Hi

There are some global variables pre-defined on the tDBOutput component, such as:

((Integer)globalMap.get("tDBOutput_1_NB_LINE_INSERTED"))

this variable stores the total number of inserted rows.

these kind of global variables can be used directly in next subjob, for example:

tFileInputDelimited--main-tMysqlOutput

|onsubjobok

tJava

on tJava:

System.out.println("the total number of inserted rows is: "+((Integer)globalMap.get("tDBOutput_1_NB_LINE_INSERTED")));

Regards

Shong