[
https://issues.apache.org/jira/browse/DERBY-7045?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838096#comment-16838096
]
Rick Hillegas commented on DERBY-7045:
--------------------------------------
It used to be possible to download a free copy of the SQL Standard. I can't
find any way to do that now. Section 21 defines language for embedding SQL in a
number of host languages.
Statements like DECLARE and IF are part of procedural extensions to the
Standard, which many databases support. They are used to write the execution
logic of a database procedure in a way which can be included as part of the
CREATE PROCEDURE statement. Derby does not support any of these procedural
statements. Derby database procedures are written in Java as described by the
SQL Reference Manual (see
http://db.apache.org/derby/docs/10.15/ref/rrefcreateprocedurestatement.html)
and the SQL Developer's Guide (see
http://db.apache.org/derby/docs/10.15/devguide/cdevspecial42117.html). Please
consult those documents if you need to write procedural code which runs inside
the Derby engine.
> Declare variable not supported in derby
> ---------------------------------------
>
> Key: DERBY-7045
> URL: https://issues.apache.org/jira/browse/DERBY-7045
> Project: Derby
> Issue Type: Improvement
> Reporter: Naresh
> Priority: Major
>
> Hi Team,
> Can you please confirm if Derby DB is supporting declaration of a variable.
> I have listed below example similar to that we need to declare variable in
> derby db .
> DECLARE count INTEGER;
> DECLARE status VARCHAR;
> Similar to above use case I would like to declare a variable in derby db. Can
> you please help me on this issue.
> Thanks,
> Naresh.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
