[
https://issues.apache.org/jira/browse/DERBY-4566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12839696#action_12839696
]
Rick Hillegas commented on DERBY-4566:
--------------------------------------
Hi Sylvain. This is a very interesting topic. I think there are at least 2
separate use cases in here:
1) Filtering and joining metadata results.
2) Using scalar variables to control branching and looping.
I think that (1) is largely addressed by the functions and table functions
attached to DERBY-3973. Those routines are more powerful than the SHOW
commands. Some effort could be put into making the DERBY-3973 routines always
available.
I would support some limited effort around (2). In particular, I would like to
be able to declare integer variables, perform simple arithmetic on them, and
use them to control a loop. I have often wanted this capability in ij in order
to populate tables for a test.
Thanks,
-Rick
> 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
>
> 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.
