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

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

RMotta2408 — Mon, 13 Oct 2025 12:44:33 GMT

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

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

Denis_Segard — Mon, 13 Oct 2025 12:50:59 GMT

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

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

RMotta2408 — Mon, 13 Oct 2025 12:55:56 GMT

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.

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

RMotta2408 — Mon, 13 Oct 2025 12:57:54 GMT

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

Thank you