On Tue, 29 Feb 2000, Hiroshi Inoue wrote:
> > -----Original Message-----
> > From: Karel Zak - Zakkr [mailto:zakkr@zf.jcu.cz]
> >
> > > > EXECUTE name [ INTO x, y, ... ] [ USING a, b, ... ]
> > >
> > > This command "Associate input parametrs and output targets
> > with a prepared
> > > statement and execute the statement" (SQL92).
> > >
>
> I don't know well about PREPARE statement.
> But is above syntax for interative SQL command ?
> Isn't it for embedded SQL or SQL module ?
- PREPARE save to cache any standard sql command (OptimizableStmt).- EXECUTE run this cached plan (query) and send data
tofrontend or INTO any relation.
Or what you mean?
Karel