cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
GaryHaut
‎03-08-2024
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

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

by Calcite | Level 5 in SAS Procedures
‎03-08-2024 09:25 AM
‎03-08-2024 09:25 AM
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? ... View more

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

by Calcite | Level 5 in SAS Procedures
‎03-07-2024 05:20 PM
‎03-07-2024 05:20 PM
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. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-08-2024 02:30 PM
Quick links