Hello all I liked the LISTAGG on Oracle and now the STRINGAGG on HANA which was introduced either at Revision 70 or 71 - we are now on Rev. So selecting data in DB02 - SQL Editior works with the following Statement: select ebeln, ebelp, stringagg(text, ' n br' ORDER BY LINE ASC ) as text from zbwstxl group by ebeln, ebelp I do have installed the HANA ODBC Driver Version 1.00.112.03 on my MS SQL Server and created a linked Server. This Statement works so far: select. from openquery (UP1, 'SELECT. FROM SAPSR3.ZBWSTXL ') Because I thought that the openquery Expression will passthrought the Statement to the source database, i wanted to use the STRINGAGG function in my openquery Statement like follow: select.fromopenquery (UP1,'SELECT EBELN, EBELP, STRINGAGG(text, ',') AS TEST FROM SAPSR3.ZBWSTXL WHERE TDOBJECT = 'EKPO' GROUP BY EBELN, EBELP ') But the OleDB is now returning the following: OLE DB provider 'MSDASQL' for linked server 'UP1' returned message 'Requested conversion is not supported.' Msg 7341, Level 16, State 2, Line 1 Cannot get the current row value of column 'MSDASQL.TEST' from OLE DB provider 'MSDASQL' for linked server 'UP1'. I know there is a more actual ODBC Driver (Think 122) available - but before I triy and error I wanted to ask if anybody already has the newest Driver and experience in this area with linked Server and function STRINGAGG?
Thank you Roger Heckly. Dynasty warriors 5 special pc english.
Hi, if you have an account for the SAP Support Portal (customer, partner, ask-your-administrator), then just enter SAP HANA client in the search bar. Take 2.0 and select the operating system (Windows, I assume). If you do not have an SAP support account, you can also download the SAP HANA client from the Developer community / This will direct you to the SAP store; also requires an account but this one is free. If you want to learn more about SAP HANA, try the SAP HANA Academy on with 1000's of free tutorials.
Sap Hana Odbc Driver 32 Bit Download
Thanks for watching!
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |