minohara@isvax.islab.melco.JUNET (Tatsuo Minohara) (04/26/88)
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 !!