Re: DBI v2 - The Details - :name for placeholders

On Sun, Jul 10, 2005 at 10:06:00PM -0700, Darren Duncan wrote:
> At 9:27 PM -0700 7/10/05, Jonathan Leffler wrote:
> >This is not what DBI deals with - it deals more nearly with the CLI
> >syntax, where that is not, as far as I know, permitted.
>
> My impression of DBI is that it is a stand-in of sorts for a SQL CLI,
> and does or should do all of the same sorts of things. Each time you
> run a SQL statement, it is like typing said statement into a CLI.
> (In fact, I seem to recall that DBI ships with a simple SQL CLI
> program that runs on top of it, and that has an almost 1:1 mapping.)
> DBI abstracts the CLI a bit by providing things like connect()
> methods rather than having users execute 'CONNECT TO ...' SQL, but
> that doesn't really change what I've said. So DBI is basically the
> same as CLI but that it is easier for programmers to use by replacing
> an input terminal with functions. In that context, the :foo syntax
> corresponds to what bind_var() etc maps to.

Seems like you've not got the right meaning of CLI here.
It's Call Level Interface not Command Line Interface.

The relevant (old) standards are:

- The X/Open CAE Specification "Data Management: SQL Call-Level Interface (CLI)"
- ISO/IEC 9075-3:1995 (E) Call-Level Interface (SQL/CLI)

There are later versions of ISO/IEC SQL/CLI for 1999 and 2003.

Tim.