On 7/9/05, Darren Duncan <[EMAIL PROTECTED]> wrote: > > At 1:03 AM -0700 7/9/05, Jonathan Leffler wrote: > >Can you explain which parts of the SQL:2003 mandate this notation? > >I've had a moderately good poke around my copy of ISO/IEC > >9075-2:2003 (SQL/Foundation) and cannot find this. I'd like a few > >section numbers listed which describe this. > >The various places I've looked include: 19.6 (prepare statement), 9 > >(Additional Common Rules), 6.4 (<value specification> and <target > >specification>). I could have missed something in these places - or > >I could be looking in the wrong place. > > Yes, I can quote some, in different places. Look at these: > > SQL:2003, 4.29 "Host parameters" (pp90,91,92) > SQL:2003, 5.4 "Names and identifiers" (pp151,152) > SQL:2003 Foundation page 152 says: > <host parameter name> ::= <colon><identifier> > > See that last line in particular. I don't see how it could be more clear.
Oh - hmmm...Embedded SQL...Yes, even Informix supports that notation in Embedded SQL/C (ESQL/C); I'd forgotten about it because it is not part of what goes to the (Informix) server. EXEC SQL EXECUTE :prepared_stmt USING :hostvar1:indvar1, :hostvar2:indvar2, ...; 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. However, I'm not yet sure about all the contexts in which a <host parameter name> can appear - it is the sort thing that is quite hard to determine from the standard, unfortunately. Even with my heavily hyperlinked grammar - generated from the BNF in the standard - it is fairly hard to tell. Consider my objection temporarily on ice - I'm not wholly convinced, but clearly the onus is on me to show why it should not be mandated by DBI v2. This is my main source for the SQL:2003 documentation: > > http://www.wiscorp.com/SQLStandards.html Thanks. I have copies of the official standard - but I didn't have the presentations, etc. If anyone wants to use my hyperlinked HTML version of the standard SQL syntax, let me know and I'll make it available for download on a website. I updated it last week, so the version I have at home isn't current (though most people wouldn't notice the change - it was very minor and solely related to formatting). -- Jonathan Leffler <[EMAIL PROTECTED]> #include <disclaimer.h> Guardian of DBD::Informix - v2005.01 - http://dbi.perl.org "I don't suffer from insanity - I enjoy every minute of it."