RE: Java UDF and SQLSTATE 42724

If you haven't solved this already, it would be helpful to see the java
method.  Also, is there an SQLCODE and a reason code to narrow down the
cause for the 42724?  Is there a JDBC method invocation that is causing the
42724?  If so, there should be a stack trace.

Thanks,
Gary

> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> Ron_H_Java@xxxxxxxxxx
> Sent: Monday, May 08, 2006 10:04 PM
> To: java400-l@xxxxxxxxxxxx
> Subject: Java UDF and SQLSTATE 42724
> 
> Hi
> 
> I'm trying to get a Java DB2 UDF to work on V5R3 connecting 
> to SQL Server 2000.
> I've got everything to work except for one column 
> (BuyerRating) that is defined as Decimal (3,2).
> When I go into STRSQL on the iSeries and run a statement the 
> function keeps failing with SQLSTATE 42724 .
> If I remove the BuyerRating column from my UDF, it works fine.
> 
> On the iSeries I define the table as such:
> 
> CREATE FUNCTION BI.Buyer(parmWhere VARCHAR(512)) 
> RETURNS TABLE (SourceID                      Int, 
>                BuyerNumber                   Char(5), 
>                BuyerName                     Char(25), 
>                DepartmentNumber              Char(4), 
>                NumberOfOrdersLate            Dec(5,0), 
>                NumberOfOrdersEarly           Dec(5,0), 
>                NumberOfOverShipments         Dec(5,0), 
>                NumberOfUnderShipments        Dec(5,0), 
>                DateThisRecordLastMaintained  Date, 
>                BuyerRating                   Dec(3,2), 
>                BuyerUserId                   CHAR(10), 
>                IfmUserId                     CHAR(10), 
>                Source                        CHAR(20)) 
> EXTERNAL NAME 'PurchaseStarBuyer.buyer' 
> LANGUAGE Java
> PARAMETER STYLE DB2General
> FENCED
> NO SQL
> DISALLOW PARALLEL
> SCRATCHPAD
> FINAL CALL
> RETURNS NULL ON NULL INPUT 
> 
> 
> The SQL Server table is defined as: 
> 
> SourceID                        10      0       int
> BuyerNumber                     5       0       char
> BuyerName                       25      0       char
> DepartmentNumber                4       0       char
> NumberOfOrdersLate              5       0       decimal
> NumberOfOrdersEarly             5       0       decimal
> NumberOfOverShipments   5       0       decimal
> NumberOfUnderShipments  5       0       decimal
> DateThisRecordLastMaintained    23      3       datetime
> BuyerRating                     3       2       decimal
> BuyerUserId                     10      0       char
> IfmUserId                       10      0       char
> Source                          20      0       char
> 
> 
> Anyone have any ideas how I can fix this problem so the 
> BuyerRating column would not cause this issue?
> ALL other columns work, it's just when I add the BuyerRating 
> column with 2 decimal positions that it stops working.
> 
> Thank You
> Ron
> --
> 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.
> 
>