Problem Note 66644: The DBSASLABEL=DBMS data set option does not generate column labels from column names when you use it with SAP HANA tables
 |  |  |  |  |
The DBSASLABEL=DBMS data set option does not generate column labels from the column names when you use it with SAP HANA tables.
For example, you encounter the issue if you run code similar to the following:
proc sql;
create table work.hasLabels as
select * from hanalib.hasHanaLabels(dbsaslabel=DBMS);
quit;
run;
If you run this code and your SAP HANA table has labels, the hasLabels SAS data set should have labels. Instead, the hasLabels data set returns the column name as a label, not as an actual database label.
To obtain a fix for this issue, contact SAS Technical Support.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to SAP HANA | Linux for x64 | V.03.04 | 2020.1.1 | Viya | Viya |
| Microsoft® Windows® for x64 | 9.45 | 2020.1.1 | 9.4 TS1M6 | Viya | ||
| 64-bit Enabled AIX | 9.45 | 2020.1.1 | 9.4 TS1M6 | Viya | ||
| 64-bit Enabled Solaris | 9.45 | 2020.1.1 | 9.4 TS1M6 | Viya | ||
| HP-UX IPF | 9.45 | 2020.1.1 | 9.4 TS1M6 | Viya | ||
| Solaris for x64 | 9.45 | 2020.1.1 | 9.4 TS1M6 | Viya | ||
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesA fix for this issue for SAS/ACCESS Interface to SAP HANA 9.46 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I6F.html#66644| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-09-16 12:03:09 |
| Date Created: | 2020-09-14 16:19:19 |