RE: Calling Stored Procedure on Sybase from iSeries -- MIDRANGE-L

× 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.

Subject: RE: Calling Stored Procedure on Sybase from iSeries
From: "DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>
Date: Thu, 15 Jan 2004 08:45:53 -0600
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

Seth,

If you can configure Sybase to use DRDA, then you might (should) be able to
get DB2 to connect to it.  DRDA is one of the standard communications
architectures used to connect databases.  I am sure that Sybase can access
DRDA databases, just not sure if it can service DRDA requests from other
systems.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Lee, Seth [mailto:Seth.Lee@xxxxxxx]
Sent: Wednesday, January 14, 2004 10:53 AM
To: 'midrange-l@xxxxxxxxxxxx'
Subject: Calling Stored Procedure on Sybase from iSeries


Good morning, everyone.
 
Does anyone know if it is possible to use embedded SQL or SQL CLI to connect
to a Sybase environment and access a stored procedure returning a result set
from the iSeries (V5R2)?  
 
Almost every bit of online information pertaining to remote stored procedure
interface views the iSeries as the server/host as opposed to the client.  
 
Any insight is greatly appreciated.
 
Regards,
 
Seth Lee

As an Amazon Associate we earn from qualifying purchases.

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.