× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Dear Forum.
I need some assistance! I want to connect to a DB2 database running on a
z/OS.

I have defined the system in the "Work with Relational Database
Directory Entries" panel on the AS/400.

I have started an Interactive SQL session via the STRSQL command.

I get the following message when attempting to connect to the DB2
database;

This is the command (and yes I did specify a valid user and password
combination)

> CONNECT TO DB2D USER ABBP001 USING ''

SQL package creation failed.
------------------------------------------------------------------------
---
                        Additional Message Information

 

Message ID . . . . . . :   SQL7020       Severity . . . . . . . :   30

Message type . . . . . :   Diagnostic

 

Message . . . . :   SQL package creation failed.

Cause . . . . . :   An SQL package must exist on the application server
to run
  SQL statements. Creation of a package for this purpose failed on the

  application server and returned SQLCODE -567, SQLSTATE 42501. The name
of   
  the package being created was QSQL2000 in schema QSQL400 on relational

  database DB2D.

Recovery  . . . :   Do the response as indicated for the SQLCODE -567
and     
  SQLSTATE 42501. If you are running with commitment control, exit
Interactive
  SQL or Query Manager and issue a CL COMMIT or ROLLBACK command. This
will   
  enable you to continue processing at the local system.

------------------------------------------------------------------------
---
  
What else should I be doing to get a successful connection?

Regards,
Dennis Nel
Production Support Manager
ABSA Corporate & Merchant Bank

* dennisn@xxxxxxxxxx   
* +27 (0)11 350-8109
* +27 (0)11 350-8379
* +27 (0)82 491-6892
161 Main Street, Johannesburg, 2001
Po Box 2683, Johannesburg, 2000

___________________________________________________________

Important Notice: 
Authorised Financial Services Provider

Important restrictions, qualifications and disclaimers 
("the Disclaimer") apply to this email. To read this click on the 
following address or copy into your Internet browser: 

http://www.absa.co.za/ABSA/EMail_Disclaimer

The Disclaimer forms part of the content of this email in terms of 
section 11 of the Electronic Communications and Transactions 
Act, 25 of 2002. 

If you are unable to access the Disclaimer, send a blank e-mail 
to disclaimer@xxxxxxxxxx and we will send you a copy of the 
Disclaimer.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.