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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error trying to read data form a DB2 file on an AS400

When I try to read data from a DB2 file (to the tLogRow) I am getting the errors below.
I connect OK (the Check is successful) using an ODBC connection (defined on my computer) and also when I use the AS400 connection that comes with open studio.
(I never got the two "DB2" types of connections to pass the check).
Any help would be appreciated. Thank you.
Errors:
1)
Starting job ReadAS400 at 14:02 28/10/2009.
connecting to socket on port 4072
connected
connecting to socket on port 5026
connected
Exception in component tDBInput_2
java.sql.SQLException: SQL0204 - KMASTER in QGPL type *FILE not found.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at test1.readas400_0_1.ReadAS400.tDBInput_2Process(ReadAS400.java:3966)
at test1.readas400_0_1.ReadAS400.runJobInTOS(ReadAS400.java:6779)
at test1.readas400_0_1.ReadAS400.main(ReadAS400.java:6682)
disconnected
disconnected
Job ReadAS400 ended at 14:02 28/10/2009.
Alternatively, I get
2)
Starting job ReadAS400 at 11:12 27/10/2009.
Exception in component tAS400Input_1
java.sql.SQLException: Token . was not valid. Valid tokens: + - AS <IDENTIFIER>.
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:1578)
at com.ibm.as400.access.AS400JDBCStatement.executeQuery(AS400JDBCStatement.java:2136)
at test1.readas400_0_1.ReadAS400.tAS400Input_1Process(ReadAS400.java:2321)
at test1.readas400_0_1.ReadAS400.runJobInTOS(ReadAS400.java:3951)
at test1.readas400_0_1.ReadAS400.main(ReadAS400.java:3868)
Job ReadAS400 ended at 11:12 27/10/2009.
Labels (4)
5 Replies
Anonymous
Not applicable
Author

I found a solution.
Anonymous
Not applicable
Author

Hello
Please share your solution with other users.
Thanks for your support!
Best regards
shong
_AnonymousUser
Specialist III
Specialist III

I'm not sure what Shlomo's solution was, but I can provide mine. I was also getting the "*FILE not found" error with an ODBC connection to JD Edwards' DB2. I was using the "iSeries Access for ODBC Driver". When I changed the driver to the "Client Access ODBC Driver (32 bit)" the error did not come up.
Hope this helps
- Russell
Anonymous
Not applicable
Author

Why didn't you use the AS400 component and jdbc ?
rlmagidson
Contributor
Contributor

Neth - I'm experienced with ODBC but fairly new to AS/400... I originally tried the AS/400 component and once I saw that hex values were coming back decided to try the iSeries ODBC driver. Since the output was clean it made my decision.