https://communities.sas.com/t5/SAS-Viya/Viya-4-and-SAS-ACCESS-to-DB2-To-Read-V9-7-Database/m-p/902617#M2085 <P>The <A href="https://documentation.sas.com/doc/en/itopscdc/v_045/itopssr/p03lkog7sche30n16nz48rhqe2ka.htm#p0iifjwq5sdv23n1lrcokwgq1vxp" target="_self">documentation</A> is pretty clear:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Patrick_0-1699668960343.png" style="width: 962px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/89673iF692E0CB3885F5F7/image-dimensions/962x203?v=v2" width="962" height="203" role="button" title="Patrick_0-1699668960343.png" alt="Patrick_0-1699668960343.png" /></span></P> <P>Not sure if it would be possible via SAS Access to ODBC.&nbsp;</P> <P>&nbsp;</P> <P>I recommend you contact SAS Tech Support directly with your question.&nbsp;</P> <P>&nbsp;</P> Sat, 11 Nov 2023 02:23:26 GMT Patrick 2023-11-11T02:23:26Z https://communities.sas.com/t5/SAS-Viya/Viya-4-and-SAS-ACCESS-to-DB2-To-Read-V9-7-Database/m-p/902580#M2084 <P>We have a customer who needs to use SAS/ACCESS to DB2 to access DB2 V9.7 DB.</P><P>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?</P><P>&nbsp;</P><P>We ask this question because we found that using the DB2 V11.5 client to access the V9.7 database will return the error:</P><P>&nbsp;</P><P>db2 'select count(*) from pme.contract'</P><P>SQL0805N&nbsp; Package "NULLID.SQLC2P31 0X414141414147466B" was not found.</P><P>SQLSTATE=51002</P><P>&nbsp;</P><P>Any experience can share with us?</P> Fri, 10 Nov 2023 19:14:33 GMT https://communities.sas.com/t5/SAS-Viya/Viya-4-and-SAS-ACCESS-to-DB2-To-Read-V9-7-Database/m-p/902580#M2084 eddieleung305 2023-11-10T19:14:33Z https://communities.sas.com/t5/SAS-Viya/Viya-4-and-SAS-ACCESS-to-DB2-To-Read-V9-7-Database/m-p/902617#M2085 <P>The <A href="https://documentation.sas.com/doc/en/itopscdc/v_045/itopssr/p03lkog7sche30n16nz48rhqe2ka.htm#p0iifjwq5sdv23n1lrcokwgq1vxp" target="_self">documentation</A> is pretty clear:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Patrick_0-1699668960343.png" style="width: 962px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/89673iF692E0CB3885F5F7/image-dimensions/962x203?v=v2" width="962" height="203" role="button" title="Patrick_0-1699668960343.png" alt="Patrick_0-1699668960343.png" /></span></P> <P>Not sure if it would be possible via SAS Access to ODBC.&nbsp;</P> <P>&nbsp;</P> <P>I recommend you contact SAS Tech Support directly with your question.&nbsp;</P> <P>&nbsp;</P> Sat, 11 Nov 2023 02:23:26 GMT https://communities.sas.com/t5/SAS-Viya/Viya-4-and-SAS-ACCESS-to-DB2-To-Read-V9-7-Database/m-p/902617#M2085 Patrick 2023-11-11T02:23:26Z