SAP HANA Notes

Change System User's Password

ALTER DATABASE <DB> SYSTEM USER PASSWORD <new password>

Log Into HANA Database

hdbsql -i <instance> -n <server> -d <DB> -u <user> -p <password>

Use wildcard in select statement

select * from "schema"."table" where "field" like '%value%'

List Tenants in HANA Database

select * from "sys"."m_databases"

List HANA User

hdbuserstore list

DATA FILE       : /home/<sid>adm/.hdb/<server>/SSFS_HDB.DAT
KEY FILE        : /home/<sid>adm/.hdb/<server>/SSFS_HDB.KEY

KEY DEFAULT
  ENV : <server>:<port>
  USER: <user>
  DATABASE: <db>

Update HANA User Store

hdbuserstore SET DEFAULT "<server>:<port>@<db>" <user> <password>

SAP Help Pages

http://help.sap.com/hana_platform

SAP HANA Studio

http://help.sap.com/saphelp_hanaplatform/helpdata/en/c8/aa369bbb57101497c4e0f9c1028266/frameset.htm

HANA SQL Reference

help.sap.com/hana/SAP_HANA_SQL_Script_Reference_en.pdf

Free HANA Trial Database

hanatrial.ondemand.com

The SAP HANA Reference for SAP Basis Administrators

http://scn.sap.com/community/hana-in-memory/blog/2013/05/27/andy-silvey--sap-hana-command-line-tools-and-sql-reference-examples-for-netweaver-basis-administrators