Ansicht
Dokumentation

SQL0805 - SQL package &1 in &2 not found at DRDA Server. ( OS/400 )

Addresses (Business Address Services)   General Data in Customer Master  
This documentation is copyright by IBM.


Message : SQL0805
SQL package &1 in &2 not found at DRDA Server.

Message Long Text :

Cause . . . . . : A remote request was attempted to &4 for SQL package &1 in &2. The SQL package was not found. If you are using Interactive SQL or Query Manager, an attempt to create a package on the remote system failed and the package requested does not exist.
Recovery . . . : The most common cause of this problem in an Interactive SQL session to a server that is not DB2 for IBM i is that the connection is not updateable. In that case the package cannot be automatically created. To ensure the connection is updateable, do a RELEASE ALL command followed by a COMMIT before connecting to the relational database.
In other cases, the SQL package can be created by using the CRTSQLPKG command. Also, precompiling an SQL program with the RDB parameter specified will create an SQL package on the system. Create or restore the SQL package. Run the application again.
If you are using Interactive SQL or Query Manager or SQL Call Level Interface, exit the product or application and enter a CL COMMIT or ROLLBACK command. This will enable you to continue processing at the local system. Determine why the package creation failed by examining the job log. Correct the problem and attempt the Interactive SQL or Query Manager session again.

Message File : QSQLMSG
Library Message File : QSYS2924


Fill RESBD Structure from EBP Component Structure   BAL Application Log Documentation  
This documentation is copyright by IBM.

Length: 3232 Date: 20240427 Time: 010455     sap01-206 ( 3 ms )