DATA Step, Macro, Functions and more

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

Reply
Occasional Contributor
Posts: 16

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

from what material i have read so far SAS v9.3 doesn't seem to support it.
SAS Super FREQ
Posts: 8,868

Re: Is there anyway to access DB2 database LOB,BLOB,CLOB type columns in 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
Occasional Contributor
Posts: 16

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

thank you Cynthia.
Ask a Question
Discussion stats
  • 2 replies
  • 321 views
  • 0 likes
  • 2 in conversation