RE: Java & UDTF

[<SRamanujan@xxxxxxxxxxxxxxxxxx>]

Pillai,
That is part of the syntax for UDTF that returns tables. This works fine
on interactive sql.  Doesn't work from Java servlet. 
Thanks,
Sudha

Sudha Ramanujan
SunGard Futures Systems
sramanujan@xxxxxxxxxxxxxxxxxx
(312) 577 6179
(312) 577 6101 - Fax


-----Original Message-----
From: Narayanan R Pillai [mailto:strqst400@xxxxxxxxx] 
Sent: Monday, March 29, 2004 12:25 PM
To: Java Programming on and around the iSeries / AS400
Subject: Re: Java & UDTF

Sudha,

What is the "x" at the end of the Statement for ?

Pillai

----- Original Message ----- 
From: <SRamanujan@xxxxxxxxxxxxxxxxxx>
To: <java400-l@xxxxxxxxxxxx>
Sent: Monday, March 29, 2004 12:54 PM
Subject: RE: Java & UDTF


> Hi all,
>
> I am working on AS/400 sqlrpgle UDTF.  I have a function that returns
a
> table in my as/400 and trying to access it from Java.  I have the
fields
> defined as varchar and varying on sqlrpgle which works fine when I try
> to access them from sql as Select * from
> table(fn('PARM1','PARM2','PARM3))x.  but from java it is giving me
> errors.  (I have same setup and same program, as a test, as stored
> procedure and it works fine.)
>
> Any help is appreciated.
> Thanks,
> Sudha
>
> Java - SQLCall = "{select * from table(" +  Libname+'.'+funcname +
> "(?,?,?))x}";
> CallableStatement stmt = con.prepareCall(SQLcall);
>
> I know I get my error here since I have println all over the
> place.
>
> java.sql.SQLException: A character, token, or clause is not
> valid or is missing.
>
>
> _______________________________________________
> 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.