Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DB2 DATA TYPE BLOB INTO VARCHAR

2,686 views
Skip to first unread message

ROBUENO

unread,
Jan 29, 2008, 11:51:52 AM1/29/08
to
I NEED A WAY TO CONVERTER IN THE BASE DB2 DATAS TYPE (BLOB) INTO
(VARCHAR/LONG VARCHAR) TO STORE IN A VIEW. I WORK WITH THE REPORT GENERATOR
CRYSTAL REPORT AND INSIDE OF THE TOOL ENVIRONMENT I CAN´T CONVERTER VIA ODBC
THE DATAS TO PRESENT IN THE REPORT.

Serge Rielau

unread,
Jan 29, 2008, 12:39:42 PM1/29/08
to
You have to convert from BLOB to VARCHAR FOR BIT DATA. From there you
can go to VARCHAR

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Knut Stolze

unread,
Jan 30, 2008, 7:19:25 PM1/30/08
to
ROBUENO wrote:

I just posted a UDF that interprets BLOB data as CLOBs here:
http://www.dbforums.com/showthread.php?t=1626924

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

0 new messages