db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jatin Trivedi <jatin.triv...@gmail.com>
Subject Convert Sybase script to Derby
Date Thu, 23 Nov 2006 12:13:25 GMT

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.


Mime
View raw message