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

One Star

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.
One Star

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

I found a solution.
Community Manager

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

Hello
Please share your solution with other users.
Thanks for your support!
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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
One Star

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

Why didn't you use the AS400 component and jdbc ?
One Star

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

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.