[DERBY-4557] Make it possible to parameterize ij scripts.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Tools
• Issue & fix info: Newcomer
• Assignee: Unassigned
• Reporter: Richard N. Hillegas
• Created: 19/Feb/10 19:13
• Updated: 27/Jun/11 13:52

Description

It would be nice to be able to parameterize ij scripts. At a high level, this would be akin to the $N parameters which you pass on the command line to Unix shell scripts. I think it would be easiest to understand if parameter substitution happened before the script was handed to the ij parser.

It would be nice to write something like the following:

connect 'jdbc:derby:$1;user=$2;password=$3';

insert into $4( a ) values ( $5 );

or something like this:

connect 'jdbc:derby:${dbname};user=${user};password=${password}';

insert into ${tableName} values ( ${intValue} );

Issue Links

• is duplicated by: DERBY-5298 Add parameters to ij scripts
• is related to: DERBY-4566 Make it possible to define variables in ij