Re: SQL Prompt API ?

Jean Michel,

when you prompt,  it seems that interactive SQL calls QSQIPRPT (sept #3276)
with 17 parameters. Maybe if you can alter the sept and make SQL call your
own program, so you can discover the parameters . . . .
Let us know.


----------
Giuseppe.


----- Original Message -----
From: "JeanMichel" <jmpenasse@experia.com>
To: "MI Programming on the AS400 / iSeries" <mi400@midrange.com>
Sent: Friday, February 07, 2003 2:58 PM
Subject: RE: [MI400] SQL Prompt API ?


> Sorry, due to my poor english, I didn't provide you with enough
information.
>
> Let me be more precise :
>
> I'm working on one of our company's tool (a kind of CASE tool), and I want
to add SQL access capability.
> What I would like to do is to be able to key in SQL statements into a
screen and give the user a F4 key to prompt it.
>
> SEU offers this capability when adding SQL statement into HLL sources :
when we hit F4 on a SQL statement, the SQL prompt for this statement is
called exactly like in STRSQL sessions.
>
> I wonder if there is an API or another way to call thoses prompts for
specific SQL statements or if I have to write it ...
>
> Jean-Michel Penasse
> EXPERIA Europe
> jmpenasse@experia.com
> +33(0)4.76.67.07.70
> www.experia.com
>
> > -----Original Message-----
> > From: mi400-bounces@midrange.com [mailto:mi400-bounces@midrange.com]On
> > Behalf Of Joe Pluta
> > Sent: Friday, February 07, 2003 2:45 PM
> > To: MI Programming on the AS400 / iSeries
> > Subject: RE: [MI400] SQL Prompt API ?
> >
> >
> > > From: JeanMichel
> > >
> > > Is there any way to call SQL prompt, (like in SEU when coding
> > > sqlrpg program and using F4) ?
> > > I can't find any API.
> >
> > Type STRSQL.  If the SQL development kit is installed, you will get the
> > interactive SQL screen, where you can build an SQL statement using F4.
> >
> > Joe
> >
> > _______________________________________________
> > This is the MI Programming on the AS400 / iSeries (MI400) mailing list
> > To post a message email: MI400@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/mi400
> > or email: MI400-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/mi400.
> >
> >
>
> _______________________________________________
> This is the MI Programming on the AS400 / iSeries (MI400) mailing list
> To post a message email: MI400@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/mi400
> or email: MI400-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mi400.
>
>