db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: IJ scripting (variables in IJ?)
Date Mon, 25 Jan 2010 13:43:18 GMT
Hi Thomas,

ij lets you name connections, prepared statements, and cursors but 
doesn't provide a general facility for named variables.

Hope this helps,

Thomas wrote:
> Hi,
> I would like to execute a series of statements in IJ where the value returned by
> the function call executed in one statement is passed as a parameter to the next
> statement calling another procedure.
> Example:
> CALL "SF_addClient"('lastname', 'firstname') 
> ==> this function creates a new client record returning the client ID
> automatically generated which was given to the client)
> CALL "SF_addClientAddresses"('clientid', ....)
> ==> this would add some client info into a different table where clientid is a
> field in this table.
> With 
> values CALL "SF_addClient"() 
> I can see the return value, but how can I store this in a variable /use the
> return value in further processing?
> Is this possible to achieve in IJ?
> Thanks

View raw message