|
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 mailing list archive is Copyright 1997-2025 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.