Re: SQL connection between AS400 and z/OS

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/info/rzala/rzalafinder.htm

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Dennis Nel" <dennisn@xxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
11/17/2004 10:58 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Fax to

Subject
SQL connection between AS400 and z/OS






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.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.