I haven't been following this discussion closely, but .....

Have you checked the list of IBM-supplied SQL APIs?  APIs such as QSQPRCED
(Process extended dynamic SQL), QxdaProcessImmediateEDRS (Process Immediate
SQL Statement) and the like?


"Leif Svalgaard" <leif@leif.org>@midrange.com on 02/07/2003 11:56:28 AM

Please respond to MI Programming on the AS400 / iSeries

Sent by:    mi400-bounces@midrange.com

To:    "MI Programming on the AS400 / iSeries" <mi400@midrange.com>
Subject:    Re: [MI400] SQL Prompt API ?

From: JeanMichel <jmpenasse@experia.com>
> Altering SEPT is not a problem, but SQL programs for promptimg (QSQIPRPT
> are *SYSTEM domain programs and we don't want to call such programs from
> tools (we send it to customers and we don't want neither to force them
security level,
> nor to alter our programs to be *SYSTEM state)
> What we would like is a *USER domain program to call (kind of API,
"official" or not).
> Something like QCMDCHK with question mark for prompting ...

It is, of course, possible to have a *USER domain program dynamically
alter its own attribute to *SYSTEM just before calling the SQL prompter
and then going back to *USER afterwards, but this may also not be
acceptable to you. I just want to point out that it is possible.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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