• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

SAP HANA Database

Log on to Linux environment

We can connect Linux environment by using “EXTRA PUTTY” inter phase

Double click on EXTRA PUTTY Provide ID address of LINUX Environment

Select combo box ʘ SSH to Linux environment with security connection

We will get command prompt for LINUX environment

Provide Use name & password

Log on to HANA Database in Linux Environment

Provide command “SU — <Sid> dam” so, we can connect to HANA Database so we will get path as below

<host> : HDB : <Sid> adm / usr / sap / HAN HDB XK >

XX – instance number

Verify files in HANA DB

By providing command KS_LS_L

Note: This command is used for verify RAPID ANALYTICS files (TABLES, Land scopes, views)

Logon to HANA Database client Inter phase

SAP HANA HDB SQL command line cool for entering SQL Statements for executing data base procedures and query information about SAP HANA Database

You can Use HDBSQL interactively or import commands from external file and execute them in back ground.

Learn the core features of SAP HANA and become master with our expertise Training.

Features

Executing SQL statements

Executing Data base procedures

Requesting information about database catalogue

Executing commands

Overview of HDBSQL dr call options and commands

Provide command “HDBSQL – ixx – U (User’s:)

P (password)

   ↓

Instance   Untitled    Instance number

Executing Commands

SAP has provided some SQL commands to per form

Operations on HANA DB

/dc [PATTERN] list columns

/de [PATTERN] list indices

/dp [PATTERN] list procedures

/ds [NAME]         list Selenium

/dl [PATTERN] list tables

/du [NAME]      list users

/dv [PATTEREN] list views

[PATTERN] = [OWNER] [OBJECT NAME]    g  <User name>, % A%

multi line mode and editing commands in external file

a) For multi line mode will write long commands on several lines.

HDBSQL stores multiple line commands in internal command buffer.

Activities in buffers

Displaying the contents of the command buffer \p

Deleting the contents of the command buffer /r

Editing command in an External file

Executing the command buffer : /g

External file

By providing statement VI – filename .sql so, will get editor we can write multiple commands to manage HANA database.

Managing HANA database is meant by managing schemas, creating tables and managing tables.

Example:- After finishing our code we need to press “Esc” on keyboard and type “wq”

CREATE TABLE CITY

(Zip NCHAR (5) primary key,

Name NCHAR (20),

State NCHAR (2));

CREATE TABLE Customer

(CNO INTEGER PRIMARY KEY,

Title NCHAR (7),

First name NCHAR (10),

Name NCHAR (10),

Zip NCHAR (5),

Address NCHAR (25) );

/DT CUSTAMER;

COMMIT

Redirecting results on screen  or to external file

Executing external file on screen

Provide statement “hdbsql –i52– p>

“hdbsql – i52 – u <user id> – p<password) – z <file name>

Will get out put on screen

Redirecting output to external file

Provide statement ‘hdbsql – i52 – U <user id> — P <password>

F<file name> /sql O{filename> out

Displaying contents of external files (input, output) files  to display

To see the file contents provide commands

Input file                             more <file name> .SQL

Output file                          more <file name> .OUT

For an Indepth knowledge on SAP HANA, click on below

Summary
Review Date
Reviewed Item
SAP HANA Database
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on SAP HANA Database"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.