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

[GaryHaut]

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.

[SASKiwi]

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?

[GaryHaut]

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?