Re: SQL0805 error -- MIDRANGE-L

Subject: Re: SQL0805 error
From: CRPence <CRPbottle@xxxxxxxxx>
Date: Thu, 11 Feb 2010 09:30:33 -0800
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>

Buck wrote:

CRPence wrote:

sjl wrote:

Do I have to create an SQL Package on each remote system?
How do I make this work, other than switching back to static
SQL?

There is also the option to use SQL CALL to invoke a stored
procedure on the remote systems, where that procedure generates
a result set.

In order to consume a result set at the central system, wouldn't
an RPG program need to use SQL CLI?

AFaIK the SQL CLI would be required to retrieve from the result sets, whether that SQL "client level interface" is used from RPG or any other HLL should not matter.

Regards, Chuck

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.