I have the same question with you, that is how to convert mysql script to derby.

Feng Jiang

On 11/23/06, Jatin Trivedi < jatin.trivedi@gmail.com> wrote:

How can i convert the following Sybase script to Derby ?

BEGIN
DECLARE @CurrencyLT INT
DECLARE  @CURRENCYRELID  INT

select @CurrencyLT=id from eb_keyword  where value ='category:currency-list'

select @CURRENCYRELID=id from eb_relationship where name='keyword-hierarchy'

END

The above shown script assigns id's from eb_keyword and eb_relationship
tables to
CurrencyLT and CURRENCYRELID local variable respectively
--
View this message in context: http://www.nabble.com/Convert-Sybase-script-to-Derby-tf2692219.html#a7507400
Sent from the Apache Derby Users mailing list archive at Nabble.com.