db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas <Thomas.K.H...@t-online.de>
Subject IJ scripting (variables in IJ?)
Date Sat, 23 Jan 2010 22:51:40 GMT
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


Mime
View raw message