Re: Java & UDTF

["Narayanan R Pillai" <strqst400@xxxxxxxxx>]

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.