RE: Java & UDTF

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.