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.
