Inserting data into an AS400 table - error [SQL7008] table_name in database_name not valid for operation

[RMotta2408]

Hello everyone,

I'm trying to insert a record into an AS400 table and the Job gives me this message:

[SQL7008] table_name in database_name not valid for operation

But if I insert manually the same record into the same table, using DBEAVER, it works fine.

Can anyone please help me? 

I'd really appreciate some help.

Thank you

[Denis_Segard]

Hello,

The cause of SQL7008 is that Commitment control on database tables on iSeries (AKA AS400) is simply not possible without journaling (read-only access is except from this rule).
Workaround:
1.Disable transaction from talend configuration: set "Commit every" to 0 on tJDBCOutput,it means auto commit is turn on.
2.Make transaction work from AS400 side: create a journal for database tables to make the transaction work.The way to create journal,please refer to: http://www.websina.com/bugzero/faq/exception-as400.html

Kind regards
Denis

[RMotta2408 · Accepted solution]

Hi everyone,

I think I found the solution.

In the tDBOutput component, instead of using an "existing connection" (mentioning the tDBConnect component), I configured it so that the host, database, username and password are written on it. 

The Job inserts the data with no error.

I hope this helps anyone else.

Thank you.

[RMotta2408]

Thank you, Denis. 
I also found a solution. Please view my own reply.

Thank you