Monday, 18 November 2019

How to login to HDB using hdbsql

hostname:HDB:pl0adm /usr/sap/PL0/HDB02 4> hdbsql -n localhost:3<02>13 -i <02>

Welcome to the SAP HANA Database interactive terminal.

Type:  \h for help with commands
       \q to quit

hdbsql=> select * from "SYS"."M_DATABASES"
Username: system
Password:





































DATABASE_NAME,DESCRIPTION,ACTIVE_STATUS,ACTIVE_STATUS_DETAILS,OS_USER,OS_GROUP,RESTART_MODE,FALLBACK_SNAPSHOT_CREATE_TIME
"SYSTEMDB","SystemDB-PL0-02","YES","","","","DEFAULT",?

No comments:

Post a Comment