There is conversion tool available from Ispirer called SQLWays that converts
PL/SQL stored procedures to stored procedures in Java. But there is a license
cost to it.
Rohit
-------- Original message --------
From: Radu Marias <[email protected]>
Date: 09/13/2015 3:19 AM (GMT-06:00)
To: [email protected]
Subject: Re: Does Trafodion support stored procedures/functions similar to the
ones in Posgresql PL/pgSQL?
We have some PL/SQL functions that we would need to migrate to trafodion,
so I think the best option is to rewrite them in SPJ right?
On Sat, Sep 12, 2015, 23:36 Suresh Subbiah <[email protected]>
wrote:
> Hi Radu,
>
> Sorry, no. Trafodion does not have this. The closest in Traf to PL/SQL is
> SPJ.
> If you outline the use you have in mind we could discuss what the best
> option would be.
>
> Thanks
> Suresh
>
>
> On Sat, Sep 12, 2015 at 4:18 AM, Radu Marias <[email protected]> wrote:
>
> > Hi,
> >
> > In the SQL Reference Manual I noticed there are only User Defined
> Functions
> > in C (UDFs) and Stored Procedures in Java (SPJ). Does it also have
> > something like
> > http://www.postgresql.org/docs/9.4/static/plpgsql-structure.html ?
> >
> > --
> > And in the end, it's not the years in your life that count. It's the life
> > in your years.
> >
>
