Viya 4 and SAS/ACCESS to DB2 To Read V9.7 Database

[eddieleung305]

We have a customer who needs to use SAS/ACCESS to DB2 to access DB2 V9.7 DB.

From Viya doc, the DB2 client requires V11.5 or later. May I know if any implementation is using DB2 V9.7 client with Viya4 to access the DB?

We ask this question because we found that using the DB2 V11.5 client to access the V9.7 database will return the error:

db2 'select count(*) from pme.contract'

SQL0805N  Package "NULLID.SQLC2P31 0X414141414147466B" was not found.

SQLSTATE=51002

Any experience can share with us?

[Patrick · Accepted solution]

The documentation is pretty clear:

Not sure if it would be possible via SAS Access to ODBC. 

I recommend you contact SAS Tech Support directly with your question.