BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
eddieleung305
Obsidian | Level 7

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Patrick
Opal | Level 21

The documentation is pretty clear:

Patrick_0-1699668960343.png

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

 

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

 

View solution in original post

1 REPLY 1
Patrick
Opal | Level 21

The documentation is pretty clear:

Patrick_0-1699668960343.png

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

 

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

 

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Discussion stats
  • 1 reply
  • 198 views
  • 0 likes
  • 2 in conversation