db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Feng Jiang" <feng.a.ji...@gmail.com>
Subject Re: Convert Sybase script to Derby
Date Thu, 23 Nov 2006 15:18:04 GMT
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.
>
>

Mime
View raw message