tAS400Input Error (SQL5016)

One Star

tAS400Input Error (SQL5016)

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
Moderator

Re: tAS400Input Error (SQL5016)

Hi,
Is your AS400 DB connection successful? Did you see the online article Setting up a DB connection?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tAS400Input Error (SQL5016)

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
Moderator

Re: tAS400Input Error (SQL5016)

Hi,
Thanks for your feedback and sharing your experience with us, it is helpful.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.