Re: Company thought DB2 will be better than Oracle.
Date: Sat, 13 Sep 2003 14:32:41 GMT
Message-ID: <3F632A76.D3609842_at_us.ibm.com>
Binding is done to support a feature called Static/Embedded SQL. Static
SQL is suitable for situations where the SQL is somewhat predictable.
You develop the SQL as part of the application code and "embed" it into
the application so to speak. Then, you precompile, compile, link edit,
and BIND the SQL into what is called a package (which essentially is a
Load module). The package is an executable ... and when invoked, no
compilation or bind is necessary ... therefore, the performance tends to
be significantly better than dynamic SQL.
Larry Edelstein
Neil Truby wrote:
> > Larry Edelstein
> >
> > Neil Truby wrote:
>
> > > You forgot to mention that lovely old IBM tradition, BINDing.
> > "Larry Edelstein" <lsedels_at_us.ibm.com> wrote in message
> news:3F631D4B.899933B5_at_us.ibm.com...
>
> > Which many people see as an advantage by the way ...
>
> Please expand ..?
Received on Sat Sep 13 2003 - 16:32:41 CEST