Re: UDTF returning Binary column to iSeries

According to http://www.redbooks.ibm.com/redbooks/pdfs/sg246503.pdf (around
pg 195) the SQL type "CHAR(x) AS BIT DATA" is not available to Java UDTFs
using the PARAMETER STYLE JAVA, and so must be dealt with using PARAMETER
STYLE DB2GENERAL as a com.ibm.db2.app.Blob object.

HTH.

-blair

  ___   _           Blair Wyman                  IBM Rochester
 ( /_)  /  _  ' _   (507)253-2891            blairw@xxxxxxxxxx
__/__)_/_<_/_/_/_'  Opinions expressed may not be those of IBM



                                                                           
             Ron_H_Java@xemaps                                             
             .com                                                          
             Sent by:                                                   To 
             java400-l-bounces         java400-l@xxxxxxxxxxxx              
             @midrange.com                                              cc 
                                                                           
                                                                   Subject 
             11/24/2006 05:01          UDTF returning Binary column to     
             PM                        iSeries                             
                                                                           
                                                                           
             Please respond to                                             
             Java Programming                                              
             on and around the                                             
              iSeries / AS400                                              
             <java400-l@midran                                             
                  ge.com>                                                  
                                                                           
                                                                           




I have a UDTF function returning data from a SQL Server 2000 table to the
iSeries.
One of the columns in the SQL Server table is type binary and I so far
have not been able to get the data back to the iSeries as it existed in
SQL Server.

According to the "Microsoft SQL Server to IBM DB2 UDB Conversion Guide"
SQL "binary" maps to DB2 as "Char(x) as Bit Data".
The problem is in the Java, in Java the "binary" data type should map to a
"byte [ ]" but when I try to perform the "set" operation in Java the RAD
IDE doesn't allow it because of error: "The method set(int, short) in the
type UDF is not applicable for the arguments (int, byte[])"

I've also tried reading the binary column as a string but and in DB2 as a
Char(15) column but data is simply not the same.

Anyone have ideas about how to create a UDTF that reads SQL Server
"binary" data type and returns the column to DB2?

Thank You

Ron


The information contained in this message, and any attachments, are or may
be privileged and/or confidential and protected from disclosure and may
also be covered by the Electronic Communications Privacy Act, 18 U.S.C.
2510-2521. If the recipient of this message is not the intended recipient
or authorized to receive this information for the addressee, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error please delete it from your computer immediately.





--
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.