Re: External SQL procedure must be ILE? -- MIDRANGE-L

Subject: Re: External SQL procedure must be ILE?
From: CRPence <CRPbottle@xxxxxxxxx>
Date: Tue, 15 May 2012 07:57:17 -0700
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>

On 15 May 2012 07:19, Michael Schutte wrote:

I could of sworn that I've seen someone call an external RPG3 program
using external SQL procedure. I'm obviously wrong because I just
received a message in the joblog saying that it must be an ILE
program. <<SNIP>>

There are "data type" restrictions. For example with CLP, there is no support for a VARCHAR parameter [even though the CL could easily approximate its effect, just like was presumed\allowed for INTEGER.

Rather than merely stating "a message in the joblog saying...", why not include specifically what was the error message identifier, the associated first and second level text, and the context of the error condition, by actually including the spooled\formatted message text in the message; and the joblog header also includes the release level?

Regards, Chuck

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: External SQL procedure must be ILE? , Michael Schutte

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.