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

[saroj]

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

[Cynthia_sas]

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

[saroj]

thank you Cynthia.