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.
