Re: trigger call java class

["Sultan yılmaz" <yilmazsultan@xxxxxxxxx>]

Hi,

yes you're right.But i try other method that  the link my mentioned.And it
works without parameters.It is table function and i want to run it with
parameters and the parameter style= db2general

:(

Sultan

On 7/11/07, Paul Nicolay <Paul.Nicolay@xxxxxxxxxx> wrote:
> Hi,
>
> Your CREATE FUNCTION is different as mine !
>
> The parameter style should be "java" instead of "db2general" !  (unless
> you take other considerations as explained on the link you mentioned in your
> previous posts).
>
> Kind regards,
> Paul
>
> ----- Oorspronkelijk bericht -----
> Van: Sultan yılmaz [mailto:yilmazsultan@xxxxxxxxx]
> Verzonden: woensdag, juli 11, 2007 10:29 AM
> Aan: 'Java Programming on and around the iSeries / AS400'
> Onderwerp: Re: trigger call java class
>
> Hİ,
>
> Unfortunately it does not work.I try the way  that mentioned in your
> mail.But i does not work.
> the following error occured:
>
> [SQL4304]  Java stored procedure or user-defined function PROPER, specific
> name PROPER could not load Java class TSTUDF for reason code 2.
>
>
> Details:
>
> create function proper(VARCHAR(255),VARCHAR(255))
>    returns varchar(255)
>     external name 'TSTUDF.JVMORCL' language java
>     parameter style db2general fenced no sql
>     disallow parallel scratchpad
>
> SELECT proper('test','test') FROM SYSIBM.SYSDUMMY1 AS A
>
> *
>
> public* *class* TSTUDF {
>
> *public* *static* String JVMORCL(String property, String value)
> *throws*Exception
> *{*
>
> *....*
>
> *}*
>
> I read mails,forums,red books.But i can't solve problems.
>
> I can run only table funtion with no parameters.But i has to run it with
> parameters.
>
> what can i do?
>
> Sultan
>
>
>
>
>
>
>
>
> On 7/10/07, Paul Nicolay <Paul.Nicolay@xxxxxxxxxx> wrote:
> >
> > Hi,
> >
> > You can pass parameters by defining them on the CREATE FUNCTION.
> >
> > For example;
> >
> > create function MyUDF(varchar(255), varchar(255))
> >     returns varchar(255)
> >     external name 'JavaUDF.TestUDF' language java
> >     parameter style java fenced no sql
> >     disallow parallel scratchpad
> >
> > .. with...
> >
> > public class JavaUDF {
> >
> >        public static String TestUDF(String s1, String s2) {
> >
> >                return s1.concat(s2);
> >        }
> >
> > }
> >
> > ... works fine as select MyUDF('abc', 'def') from pn/onerow
> >
> > If a combination with returning a table works is something I haven't
> > tried.
> >
> > Kind regards,
> > Paul
> >
> > ----- Oorspronkelijk bericht -----
> > Van: Sultan yılmaz [mailto:yilmazsultan@xxxxxxxxx]
> > Verzonden: dinsdag, juli 10, 2007 10:48 AM
> > Aan: 'Java Programming on and around the iSeries / AS400'
> > Onderwerp: Re: trigger call java class
> >
> > Hi again,
> >
> >
> >
> http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzaha/udftable.htm
> >
> > There is a sample function and java class in this link.
> > And public void dump (String property, String value) methods have two
> > parameters.
> > And i call function like this :SELECT * FROM TABLE(PROPERTIES())
> >
> > Why i don't call function like PROPERTIES('sample','test') with
> > parameters?
> >
> > is it possible?I want to send parameter to my java method.But how?
> >
> >
> > Sultan
> >
> >
> >
> >
> >
> > --
> > This is the Java Programming on and around the iSeries / AS400
> (JAVA400-L)
> > mailing list
> > To post a message email: JAVA400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/java400-l
> > or email: JAVA400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/java400-l.
> >
> >
> --
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>
>
>
>
> --
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.