Hello
I have a problem wiht updating db2 sequence on table
I cannot execute an update statement on table because i do not have privlagesl
I insert data using Numeric.sequence("s1,1,1") in t_map but this doesn't update the sequence on output table.
So usualy i have to open smth like RAZOR and execute statemets there and update it
the statement i use is
select nextval for pet335.s_verzijapovprecjaz from pet335.verzijapovprecjaz fetch first x row only where x stands for the number of rows that were inserted. the biggest problem is that then i have to scroll down to get to that number and if it si smht like 10 000 rows it takes lots of time - believe or not that is how it is

I tried to put t_row in talend at the end of the job  with statement
"select nextval for pet335.s_verzijapovprecjaz from pet335.verzijapovprecjaz fetch first" +((Integer)globalMap.get("tDB2Input_1_NB_LINE")) + " row only"

but i get an error
nullException in component tDB2Row_1
java.lang.NullPointerException
    at db2_pet335.verzijapovprecjaz_testnaverzija_0_1.verzijapovprecjaz_testnaverzija.tDB2Row_1Process(verzijapovprecjaz_testnaverzija.java:2333)
    at db2_pet335.verzijapovprecjaz_testnaverzija_0_1.verzijapovprecjaz_testnaverzija.tBufferInput_1Process(verzijapovprecjaz_testnaverzija.java:2274)
    at db2_pet335.verzijapovprecjaz_testnaverzija_0_1.verzijapovprecjaz_testnaverzija.tDB2Input_2Process(verzijapovprecjaz_testnaverzija.java:3740)
    at db2_pet335.verzijapovprecjaz_testnaverzija_0_1.verzijapovprecjaz_testnaverzija.runJobInTOS(verzijapovprecjaz_testnaverzija.java:3983)
    at db2_pet335.verzijapovprecjaz_testnaverzija_0_1.verzijapovprecjaz_testnaverzija.main(verzijapovprecjaz_testnaverzija.java:3856)

Any suggestions??
I saw some posts about sequences on db2 but nothing usefull

Thank you