Can I store database insert results in a table?

[Anonymous]

I created a job that puts data into a table 

insert into t1 select * from emp where deptno=20;

I want to save the work result to a table.

LNUM = PK

STIME = Start time

ETIME = end time

DMLTYPE = INSERT, UPDATE , DELETE 

ROWVAL = DML row count

ERRVAL = error values

How can I get these results?

[Anonymous]

In the end of job, you can use a tFixedFlowInput to generate this kind of log messages and insert them to DB. I have question about the LNUM column, are there might be several PK values in your query?

[Anonymous]

There is no PK in the LNUM column.

Plan to add later

When I get used to it

[Anonymous]

There are three global variables pre-defined on DB output components, these variables stores the total number of lines are inserted/updated/deleted, and you can also check the value of these variables to get the DMLTYPE.
These global variables includes:
((Integer)globalMap.get("tDBOutput_1_NB_LINE_UPDATED"))
((Integer)globalMap.get("tDBOutput_1_NB_LINE_INSERTED"))((Integer)globalMap.get("tDBOutput_1_NB_LINE_DELETED"))