You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » problem with as400 connection (commit, rollback)
Post a reply
Topic review (newest first)
- emaxt6
- 2010-04-06 17:46:36
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!
- kzone
- 2010-04-06 11:36:04
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: [SQL7008] 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[/b] 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