You can perform varchar casting using following query:SELECT TO_ALPHANUM(col) FROM ......

Note that IN statement in SQL doesn’t accept a wild character. You have to use OR/AND to make it work as mentioned below:select * from Test1 t INNER JOIN Test2 s ON t.ID = s.RID where t.sdate >= ?1 AND t.edate

You need to login to XM interface and there is different BAPI’s that you can use to read CCMS data.Function Module:BAPI_SYSTEM_ALERT_ACKNOWLEDGE BAPI_SYSTEM_ALERT_GETDETAILS BAPI_SYSTEM_MON_GETLIST BAPI_SYSTEM_MON_GETTEMPLATE BAPI_SYSTEM_MON_GETTREE You can refer this documentation to know more about Function Modules:https://archive.sap.com/kmuuid2/da4Read More

Yes, to perform an immediate login you have to navigate to Installation directory and use the following start parameters −-h  Host name-n  Instance number-u  User nameUser name with special characters should be enclosed in double quotations (“”).Windows OShdbstudio.exe -h hanademo -n 03 -u HANAADMINhdbstudio.exe -h hanademo -n 03 -u "&hanatest"Linux ... Read More

Yes, it is possible to export a list of your SAP HANA systems from the SAP HANA studio as an XML file and then it can be imported to another instance of the SAP HANA studio or use it as a system archive to which other users can link.This can ... Read More

SSO can be configured on below authentication methods −SAMLKerberosX.509 client certificates for HTTP access from HANA XS engineSAP Logon/Assertion tickets

Below is the list of authentication methods supported by SAP HANA −User name/PasswordKerberosSAML 2.0SAP Logon ticketsX.509You can configure any of authentication method while creating a new user −

When you are managing a large number of systems using HANA Studio, this can be used to find a specific system more quickly.To use find system option, the following steps should be performed −From the Systems view toolbar, choose the Find System (Find System) button.2. Enter a search string −You ... Read More

When you compare standard database users, restricted users have the following limitations −With restricted users, it is not possible to create objects in the database as they are not authorized to create objects in their own database schemaRestricted users are not authorized to view any data in the database as ... Read More

Following are the key limitations that HANA overcomes −As data size is growing it is a big problem for companies to store huge amounts of data. You talk about any industry domain- healthcare, FMCG, Banking, and Insurance, as subscribers are increasing there is an increase in historical data with time. ... Read More