Skip to Content
0
Former Member
Nov 16, 2017 at 08:33 AM

How to get list of views in SAP B1 hana?

514 Views Last edit Nov 16, 2017 at 08:33 AM 3 rev

Following SAP HANA Query is not executing in C# code. But its working in SAP HANA studio. I'm trying to fix this error for a long time.

Hana queries that I tried:

SELECT VIEW_NAME,VIEW_TYPE,SCHEMA_NAME FROM VIEWS WHERE SCHEMA_NAME ='TEST'

SELECT "VIEW_NAME","VIEW_TYPE","SCHEMA_NAME" FROM VIEWS WHERE "SCHEMA_NAME" ='TEST'

SELECT view_name,view_type,schema_name FROM VIEWS WHERE schema_name ='TEST'

SELECT "view_name","view_type","schema_name" FROM VIEWS WHERE "schema_name" ='TEST'

public dynamic ExecuteReader(string query) 
{
    SAPbobsCOM.Recordset recSet = (SAPbobsCOM.Recordset)this.m_CompanyConn.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
    recSet.DoQuery(query);
    return recSet;          
}

Error:
*****
1). [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] General error;260 invalid column name: VIEW_NAME: line 1 col 8 (at pos 7)