Is there anyway to access DB2 database LOB,BLOB,CLOB type columns in SAS

saroj — Thu, 03 Jul 2008 08:53:48 GMT

from what material i have read so far SAS v9.3 doesn't seem to support it.

Re: Is there anyway to access DB2 database LOB,BLOB,CLOB type columns in SAS

Cynthia_sas — Thu, 03 Jul 2008 15:15:28 GMT

Hi:
The two most current versions of SAS are 9.2 and 9.1.3. SAS 9.2 has just been released. SAS 9.1.3 is still active in a lot of shops.

Whether large objects (BLOB, CLOB, etc) are supported, seems to depend on the SAS/Access product. For example, with Oracle, some large objects are supported; while on the DB2 on the mainframe, it seems that large objects are not supported.

http://support.sas.com/kb/7/877.html
http://support.sas.com/kb/4/978.html
"With SAS V9 and with Oracle 9i, CLOB and BLOB will be supported exactly like LONG & LONG RAW."

http://support.sas.com/kb/9/308.html
"SAS/Access to DB2 on MVS does not support DB2 large objects including
the data types CLOB, DBCLOB, and BLOB. Often these fields are used
to hold graphs, pictures, etc."

You may want to investigate the documentation for the SAS/Access product involved in your question and/or contact SAS Technical Support for more help.

cynthia

Re: Is there anyway to access DB2 database LOB,BLOB,CLOB type columns in SAS

saroj — Fri, 04 Jul 2008 05:36:10 GMT

thank you Cynthia.

topic Re: Is there anyway to access DB2 database LOB,BLOB,CLOB type columns in SAS in SAS Programming

Is there anyway to access DB2 database LOB,BLOB,CLOB type columns in SAS

Re: Is there anyway to access DB2 database LOB,BLOB,CLOB type columns in SAS

Re: Is there anyway to access DB2 database LOB,BLOB,CLOB type columns in SAS