raw values retrieved over transparent gateway
From: Bill Jones <wjones14_at_7of9.csc.com>
Date: Mon, 14 Dec 1998 16:33:02 -0500
Message-ID: <Pine.GSU.4.02.9812141625150.13476-100000_at_explorer.csc.com>
In SQL*Plus, when we select a binary string field from a DB2 database over our Transparent Gateway, the hex equivalent is displayed (the 8-byte string is converted to 16 bytes). Likewise, if we enter the hex equivalent string in a WHERE clause, the Gateway does the automatic conversion and finds the record in DB2.
Date: Mon, 14 Dec 1998 16:33:02 -0500
Message-ID: <Pine.GSU.4.02.9812141625150.13476-100000_at_explorer.csc.com>
In SQL*Plus, when we select a binary string field from a DB2 database over our Transparent Gateway, the hex equivalent is displayed (the 8-byte string is converted to 16 bytes). Likewise, if we enter the hex equivalent string in a WHERE clause, the Gateway does the automatic conversion and finds the record in DB2.
However, in a Visual Basic program using Oracle Objects For OLE 2.3, when we select the same field from DB2, we get the 8-byte unprintable binary string. If we try to pass the string as is back to DB2 in a WHERE clause, we get no records found. Do we have to convert the string in VB somehow to use it? Thanks!
<remove 7of9 for email replies>
-- Bill Jones e-mail addresses: Computer Sciences Corp. (work) wjones14_at_csc.com Norwich, Connecticut (play) billj_at_snet.net (860) 437-5650 WWW: http://pages.cthome.net/billjReceived on Mon Dec 14 1998 - 22:33:02 CET