DB2 DATA TYPE BLOB INTO VARCHAR

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ROBUENO - 29 Jan 2008 16:51 GMT

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.

Reply to this Message

Serge Rielau - 29 Jan 2008 17:39 GMT

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

You have to convert from BLOB to VARCHAR FOR BIT DATA. From there you
can go to VARCHAR

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

Knut Stolze - 31 Jan 2008 00:19 GMT

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

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

Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Reply to this Message