[
https://issues.apache.org/jira/browse/DERBY-4566?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sylvain Leroux updated DERBY-4566:
----------------------------------
Attachment: DERBY-4566_0.3.sql
DERBY-4566_0.3.patch
Here is a third proposal for this issue.
This version adds the opportunity to use variables to control loops.And it adds
variables substitution in J-SQL strings using the ${....} notation.
The attached sql file demonstrate all these features.Here is a short extract
that performs 10 inserts in a table:
SET range AS 1..10;
FOR i IN range
EXECUTE 'insert into t2 values(${i}, 100*${i})';
The code is not yet ready for inclusion. Think of it as a proof of concept for
now. But I will be glad to have some feedbacks of this before pursuing.
Regards,
- Sylvain
> Make it possible to define variables in ij
> ------------------------------------------
>
> Key: DERBY-4566
> URL: https://issues.apache.org/jira/browse/DERBY-4566
> Project: Derby
> Issue Type: Improvement
> Components: Tools
> Reporter: Sylvain Leroux
> Assignee: Sylvain Leroux
> Attachments: DERBY-4566.sql, DERBY-4566_0.2.patch,
> DERBY-4566_0.3.patch, DERBY-4566_0.3.sql
>
>
> It would be nice to have a way in ij to store statement results in variables
> for later re-use.
> Notably, It would allow to use (meta)data obtained by some statements (such
> as SHOW ....) beyond the simple display of the result. Moreover, it could be
> a first step toward extending the scripting capabilities of ij.
> See http://old.nabble.com/IJ-scripting-(variables-in-IJ-)-td27290712.html
> Related to DERBY-4557
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
