MENU

Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Friday, December 11, 2015

HDBSQL command in hana





vsa00:HDB:ABCADM> hdbsql -i instance_number -u username -p password

Example:
vsa00:HDB:ABCADM> hdbsql -i 00 -u system -p H7by


------------OR---------------

vsa00:HDB:ABCADM > hdbsql -jU w

Welcome to the SAP HANA Database interactive terminal.

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

------------OR---------------

vsa00:HDB:ABCADM >  hdbsql -jU bkpmon

Welcome to the SAP HANA Database interactive terminal.

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

hdbsql=>


HDBSQL for Multi DB:
==================

vsa00:HDB:ABCADM> hdbsql -i instance_number -u username -p password -d db_name

Example;
vsa00:HDB:ABCADM>  hdbsql -i 02 -u SYSTEM -p lab1234 -d Systemdb

No comments: