topic Re: sqlxmsg-SQL package SAS94 in SAS94 not found at DRDA server. in SAS Procedures

sqlxmsg-SQL package SAS94 in SAS94 not found at DRDA server.

GaryHaut — Thu, 07 Mar 2024 22:20:50 GMT

I receive an error when trying to test an sql after upgrading from 9.1 to 9.4

DB2 Error:

Result of SQL Statement:

SQL0805 SQL package SAS94 in SAS94 not found at DRDA server.

A dump of the SQLCA for the get diasnostics request follows:

Row number: 0 Error Condition: 1 Reason Code: 0

SQLCODE: -805 SQLState: 51002 SQLERRP: qrwtexec

Error: SQL View WORK.DB2VIEW could not be processed because at least one of the data sets, or views, references directly (or indirectly) by it could not be located, or opened successfully.

Re: sqlxmsg-SQL package SAS94 in SAS94 not found at DRDA server.

SASKiwi — Thu, 07 Mar 2024 23:57:46 GMT

If it worked in 9.1 but not in 9.4 this may indicate a SAS/ACCESS Interface to DB2 configuration or connection problem. Talk to your SAS admin to investigate further. Do all of your other DB2 queries work and this is the only one failing?

Re: sqlxmsg-SQL package SAS94 in SAS94 not found at DRDA server.

GaryHaut — Fri, 08 Mar 2024 14:25:00 GMT

Unfortunately, all DB2 queries fail and I don't have a SAS admin to assist me. It reads like I have to 'create' a 'sas94' *SQLPKG object on the IBMi server. Are there instructions on how to do this that anyone can help me with?