topic Re: tAS400Input Error (SQL5016) in Talend Studio

tAS400Input Error (SQL5016)

_AnonymousUser — Sat, 22 Jun 2013 15:39:41 GMT

Hi,
I have got an error SQL5016 return after execution of the component tas400Input. I use the next jdbc conection :
jdbc:as400://10.190.200.21/xxxxx;libraries=xxxx;prompt=false;translate binary=true
and the return error exception is :
Exception in component tAS400Input_1
java.sql.SQLException: Nom d'objet qualifié FHPRVP00 non admis.
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 entrepot_postgresql.dimension_promotion_0_1.Dimension_Promotion.tAS400Input_1Process(Dimension_Promotion.java:2411)
at entrepot_postgresql.dimension_promotion_0_1.Dimension_Promotion.tAS400Connection_1Process(Dimension_Promotion.java:375)
at entrepot_postgresql.dimension_promotion_0_1.Dimension_Promotion.runJobInTOS(Dimension_Promotion.java:4169)
at entrepot_postgresql.dimension_promotion_0_1.Dimension_Promotion.main(Dimension_Promotion.java:4037)
If somebody can help me to resolve this problem
Best regards
Fabrice

Re: tAS400Input Error (SQL5016)

Anonymous — Mon, 24 Jun 2013 03:40:47 GMT

Hi,
Is your AS400 DB connection successful? Did you see the online article Setting up a DB connection?
Best regards
Sabrina

Re: tAS400Input Error (SQL5016)

Anonymous — Mon, 24 Jun 2013 13:46:24 GMT

Hi,
Thanks for your reply. I resolved my problem. I just change the convention name of the table *SQL to *SYS in iSeries client navigator, and now I can read the data from the database.
Best Regards,
Fab

Re: tAS400Input Error (SQL5016)

Anonymous — Tue, 25 Jun 2013 10:02:07 GMT

Hi,
Thanks for your feedback and sharing your experience with us, it is helpful.
Best regards
Sabrina