Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1489635763.33951267454945890.JavaMail.jira@brutus.apache.org>
Date: Mon, 1 Mar 2010 14:49:05 +0000 (UTC)
From: "Rick Hillegas (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-4566) Make it possible to define variables
 in ij
In-Reply-To: <369968777.500421267035448000.JavaMail.jira@brutus.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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