problem with as400 connection (commit, rollback)

Anonymous — Sat, 16 Nov 2024 13:28:24 GMT

hi all,
I'm trying to integrate file using tas400Connection !
But in tas400Ouput component appears this errors :

Exception in component tAS400Output_1
java.sql.SQLException: Table TEST_00001 de TPARMBIB incorrecte pour cette opération.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:650)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:621)
at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1399)
at com.ibm.as400.access.AS400JDBCStatement.executeUpdate(AS400JDBCStatement.java:2192)
at web_services.loadinas400_0_1.loadInAs400.tFileInputDelimited_1Process(loadInAs400.java:691)
at web_services.loadinas400_0_1.loadInAs400.tAS400Connection_1Process(loadInAs400.java:366)
at web_services.loadinas400_0_1.loadInAs400.runJobInTOS(loadInAs400.java:1678)
at web_services.loadinas400_0_1.loadInAs400.main(loadInAs400.java:1571)

The fact as I've never declared or instancied a {b]Table TEST_00001 as far as i remember !
And I cannot find any string like " TEST_00001" in the source code of my job ...
Where this "TEST_00001" come from so !?
is it a syntax you 're using during Talend test componenet !?
thanks for help
regards
laurent

"Talend Open Studio"
Version: 4.0.0RC2
Build id: r38885-20100322-0244

Re: problem with as400 connection (commit, rollback)

Anonymous — Tue, 06 Apr 2010 16:46:36 GMT

system i , or i , or as400 (if you are old school) defaults to max 10 char per table name maybe for compatibility with legacy code (think about RPG etc.).
I think your problem may be related to commit control on the connection setup (try to change isolation level, maybe to none).
hope it helps
bye!

topic problem with as400 connection (commit, rollback) in Talend Studio

problem with as400 connection (commit, rollback)

Re: problem with as400 connection (commit, rollback)