Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

problem with as400 connection (commit, rollback)

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 ! 0683p000009MACn.png
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
Labels (4)
1 Reply
Anonymous
Not applicable
Author

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!