[jira] Commented: (DERBY-4566) Make it possible to define variables in ij

["Rick Hillegas (JIRA)" <ji...@apache.org>]

    [ 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.