Path: utzoo!mnetor!uunet!kddlab!icot32!isvax!minohara
From: minohara@isvax.islab.melco.JUNET (Tatsuo Minohara)
Newsgroups: comp.databases
Subject: about SQL2 definitions (In n)
Message-ID: <1279@isvax.islab.melco.JUNET>
Date: 26 Apr 88 08:31:05 GMT
Organization: Mitsubishi Electric, Kamakura, Japan
Lines: 59
Keywords: SQL2,dynamic SQL, prepared statement

How do you do. This is T. Minohara in Japan.
I am sorry that my English is very poor.

I am reading the 'ISO SQL Working Draft Database
Language SQL2 March 1988'. I have some questions
and proposals to it. So, I am trying to send them
to the Japanese member of the working group.

If you have a copy of it, please think whether
following my opinions is correct or not, and please
reply. Thank you in advance.


1. ABOUT <dynamic parameter specification>

page 42. Syntax Rules

3) A <parameter specification> or <parameter name> shall
be contained in <module>. A <variable specification> or 
<embedded variable name> shall be contained in an <embedded
SQL statement>. A <dynamic parameter specification> shall be
contained only in a <SQL dynamic statement>.
                    -----------------------

I wonder it (the part of underline). If it would be correct,
one may write <dynamic parameter specification> (equal to '?')
in <dynamic update statement: positioned>, etc. I suppose it
must be <prepared statement> that is defined in page 215.
Therefore,

3) ........... A <dynamic parameter specification> shall be
contained only in a <prepared statement>.

2. ABOUT <prepared statement>

page 215-216. General Rules

2) The following restrictions apply to the <prepared statement>.

I propose the following explicit restrictions to the rules,
nevertheless the above definition (p.42 Syntax Rules 3) ).

f) It shall not include <parameter specification>, <parameter
name>, <variable specification> and <embedded variable name>.

For example, is the following <prepared statement> correct ?

  SELECT A, B, C  FROM  D  WHERE  E = :EMBEDVARNAME

Because it (<prepared statement>) includes the embedded variable,
I suppose it is not correct. If one use embedded variables in the
<prepared statement>, the SQL language processor of the dynamic
SQL might know the memory location of the variable in runtime.
I suppose it is impossible...
Alternatively, one may attach the word 'only' to the all paragraph
of the p.42 Syntax Rules 3). But, I think the explict restriction
is better.

			Thank you to read my Japanese-English !!