I have a UDTF function returning data from a SQL Server 2000 table to the 
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


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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.