Re: SQL Prompt API ?

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?

HTH
Dennis






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

Please respond to MI Programming on the AS400 / iSeries
       <mi400@midrange.com>

Sent by:    mi400-bounces@midrange.com


To:    "MI Programming on the AS400 / iSeries" <mi400@midrange.com>
cc:
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
our
> 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.