Skip to content

Commit b070c2b

Browse files
danielvadanielva
authored
Correct the case on SQL console (#23083)
* New tutorial on SQL Console in HCC * Additional feedback changes * Correct the case on SQL console
1 parent bd7cc0c commit b070c2b

9 files changed

Lines changed: 46 additions & 45 deletions

File tree

‎tutorials/hana-cloud-alerts/hana-cloud-alerts.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -96,7 +96,7 @@ The following instructions demonstrate a few examples of triggering alerts in a
9696

9797
![Open the database explorer](open-dbxt.png)
9898

99-
2. Execute the following query in the SQL Console to trigger a high (indicated by the parameter value of 4) severity test alert.
99+
2. Execute the following query in the SQL console to trigger a high (indicated by the parameter value of 4) severity test alert.
100100

101101
```SQL
102102
CALL _SYS_STATISTICS.Trigger_Test_Alert(?, 4, 'High test alert');

‎tutorials/hana-cloud-dl-clients-overview/hana-cloud-dl-clients-overview.md‎

Lines changed: 4 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -173,7 +173,8 @@ In this step, a sample HOTEL dataset will be created comprising tables, a view,
173173
174174
--Further privileges will be granted later to the tables, views, functions, and procedures that are created below
175175
GRANT SET ANY CUSTOMER PUBLIC OPTION, READ FILE TO HOTEL_ADMIN, HOTEL_READER;
176-
GRANT EXECUTE ON sp_list_directory, sp_real_list_directory TO HOTEL_ADMIN, HOTEL_READER;
176+
GRANT EXECUTE ON sp_list_directory TO HOTEL_ADMIN, HOTEL_READER;
177+
GRANT EXECUTE ON sp_real_list_directory TO HOTEL_ADMIN, HOTEL_READER;
177178
178179
GRANT ROLE HOTEL_ADMIN TO USER1;
179180
GRANT ROLE HOTEL_READER TO USER2;
@@ -186,7 +187,7 @@ In this step, a sample HOTEL dataset will be created comprising tables, a view,
186187
GRANT SELECT ON SCHEMA HOTEL TO HOTEL_READER;
187188
188189
SET SCHEMA HOTEL;
189-
190+
SELECT CURRENT SCHEMA;
190191
--Create the objects in the HOTEL schema
191192
CREATE TABLE HOTEL(
192193
HNO INTEGER PRIMARY KEY,
@@ -530,7 +531,7 @@ The data lake client install includes [dbisql Interactive SQL Utility](https://h
530531

531532
Additional details on the SQL used above can be found at [INSERT Statement for Data Lake Relational Engine](https://help.sap.com/viewer/19b3964099384f178ad08f2d348232a9/latest/en-US/a61fdeff84f21015aa66b9add387d7f9.html). Moreover, the [LOAD TABLE Statement for Data Lake Relational Engine](https://help.sap.com/viewer/19b3964099384f178ad08f2d348232a9/latest/en-US/7ca3f60902f3473296cb309533d89210.html) can be used for efficient mass insertion into a database table from a file with ASCII or binary data.
532533

533-
>Autocommit is set to on in the SQL Console of the database explorer, while in DBISQL it is set to off. A series of insert statements will run quicker in the SQL Console if they are surrounded with begin and end or if autocommit is set to off.
534+
>Autocommit is set to on in the SQL console of the database explorer, while in DBISQL it is set to off. A series of insert statements will run quicker in the SQL console if they are surrounded with begin and end or if autocommit is set to off.
534535
>
535536
```SQL
536537
begin

‎tutorials/hana-dbx-connections/hana-dbx-connections.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -148,7 +148,7 @@ A data lake Relational Engine is a column oriented, disk based relational store
148148
149149
![Copy SQL Endpoint](copy-sql-endpoint.png)
150150
151-
3. The catalog browser can be used to view database objects and a SQL Console can be opened to query the database.
151+
3. The catalog browser can be used to view database objects and a SQL console can be opened to query the database.
152152
153153
```SQL
154154
SELECT CURRENT USER FROM DUMMY;
@@ -200,7 +200,7 @@ Instances have additional actions that can be performed on them such as renaming
200200
201201
3. When a SQL console opens, it connects to the currently selected database instance and displays the current schema and instance name.
202202
203-
![SQL Console connections](SQL-Console-Connections.png)
203+
![SQL console connections](SQL-Console-Connections.png)
204204
205205
It is possible to connect, disconnect, or change the connection via the toolbar items highlighted above.
206206

‎tutorials/hana-dbx-create-schema/hana-dbx-create-schema.md‎

Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -29,7 +29,7 @@ The following steps will create a sample hotel dataset using create and insert s
2929

3030
![Open SQL console](open-sql-console.png)
3131

32-
Notice that the user in the SQL Console is DBADMIN if using SAP HANA Cloud, or SYSTEM if using an on-premise SAP HANA database. In this step we will create a new user, USER1 that will be used throughout the rest of the tutorials in this tutorial group.
32+
Notice that the user in the SQL console is DBADMIN if using SAP HANA Cloud, or SYSTEM if using an on-premise SAP HANA database. In this step we will create a new user, USER1 that will be used throughout the rest of the tutorials in this tutorial group.
3333

3434
2. Execute the below SQL.
3535

@@ -87,11 +87,11 @@ The following steps will create a sample hotel dataset using create and insert s
8787
8888
![add new user1 connection](user1-connection0.png)
8989
90-
Open a new SQL Console and notice that it using USER1 and the schema is HOTEL.
90+
Open a new SQL console and notice that it using USER1 and the schema is HOTEL.
9191
9292
![user1 connection sql console](user1-connection.png)
9393
94-
4. The following example demonstrates the privileges using the newly opened SQL Console. Notice that USER2 does not have the privilege to perform an insert.
94+
4. The following example demonstrates the privileges using the newly opened SQL console. Notice that USER2 does not have the privilege to perform an insert.
9595
9696
```SQL
9797
CREATE TABLE TEST(
@@ -131,7 +131,7 @@ The following steps will create a sample hotel dataset using create and insert s
131131
132132
### Create and populate tables
133133
134-
1. Create tables that represent a basic hotel administration system by running the SQL statements below in a SQL Console connected to USER1 in the schema of HOTEL.
134+
1. Create tables that represent a basic hotel administration system by running the SQL statements below in a SQL console connected to USER1 in the schema of HOTEL.
135135
136136
```SQL
137137
--CONNECT USER1 PASSWORD Password1;
@@ -313,7 +313,7 @@ The following steps will create a sample hotel dataset using create and insert s
313313

314314
Auto-commit is a setting that when enabled, causes each SQL statement to be immediately committed to the database. When auto-commit is turned off, multiple statements can be executed and then they can all be committed together, or they can all be rolled back. There are two auto-commit settings in an SAP HANA database.
315315

316-
The first setting which can be set in the SQL Console, applies to SQL statements that manipulate data such as insert, update, or delete statements. These types of statements are known as Data Manipulation Language (DML). The second setting can be set via SQL applies to SQL statements that modify database schema such create table statements or alter table statements. These types of statements are known as Data Definition Language (DDL).
316+
The first setting which can be set in the SQL console, applies to SQL statements that manipulate data such as insert, update, or delete statements. These types of statements are known as Data Manipulation Language (DML). The second setting can be set via SQL applies to SQL statements that modify database schema such create table statements or alter table statements. These types of statements are known as Data Definition Language (DDL).
317317

318318

319319
The following steps will demonstrate these settings.
@@ -335,7 +335,7 @@ The following steps will demonstrate these settings.
335335

336336
![test1 result](auto-commit-test1.png)
337337

338-
2. In the SQL Console, set auto-commit off.
338+
2. In the SQL console, set auto-commit off.
339339

340340
![turn auto-commit off](autocommit-off.png)
341341

@@ -356,7 +356,7 @@ The following steps will demonstrate these settings.
356356

357357
![auto-commit test3](auto-commit-test3.png)
358358

359-
Until a COMMIT is executed, the table will appear to have no rows inserted when viewed from another SQL Console or database connection.
359+
Until a COMMIT is executed, the table will appear to have no rows inserted when viewed from another SQL console or database connection.
360360

361361
Additional details can be found at [ROLLBACK Statement](https://help.sap.com/viewer/c1d3f60099654ecfb3fe36ac93c121bb/latest/en-US/20fcc453751910149557fc90fe781449.html) and [COMMIT Statement](https://help.sap.com/viewer/c1d3f60099654ecfb3fe36ac93c121bb/latest/en-US/20d39db97519101480e7f9b76f48c2c4.html).
362362

@@ -377,7 +377,7 @@ The following steps will demonstrate these settings.
377377

378378
An error will occur and you can then decide to undo the inserted rows and the table creation by executing a `ROLLBACK;` or you have the option to keep the successfully created table and rows by executing a `COMMIT`.
379379

380-
Until a COMMIT is executed, the table will not appear in another SQL Console or in the catalog browser.
380+
Until a COMMIT is executed, the table will not appear in another SQL console or in the catalog browser.
381381

382382
>The following query can be used to determine if AUTOCOMMIT DDL is enabled.
383383
>

‎tutorials/hana-dbx-export-import/hana-dbx-export-import.md‎

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -41,7 +41,7 @@ Methods to export tables or views
4141

4242
| Method | Version | Target | Format(s) |
4343
| ------- | -------------|------------------------| ----------------|
44-
| Export from SQL Console | All | local computer | CSV |
44+
| Export from SQL console | All | local computer | CSV |
4545
| [Export data wizard](https://help.sap.com/viewer/a2cea64fa3ac4f90a52405d07600047b/cloud/en-US/97e8ec0306eb4a12a4fd72de8bdd6a62.html) | SAP HANA Cloud, HANA database | data lake Files, S3, Azure, GCS, Alibaba OSS | CSV, Parquet, JSON (for document stores) |
4646
| [Export into statement](https://help.sap.com/viewer/c1d3f60099654ecfb3fe36ac93c121bb/latest/en-US/6a6f59bbfbb64ade84d83d7f87789753.html) | SAP HANA Cloud, HANA database | data lake Files, S3, Azure, GCS, Alibaba OSS | CSV, Parquet, JSON (for document stores) |
4747
| [Export into statement](https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/latest/en-US/6a6f59bbfbb64ade84d83d7f87789753.html) | SAP HANA on-premise | SAP HANA file system | CSV |
@@ -58,7 +58,7 @@ Methods to import into tables
5858
| [Import from statement](https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/latest/en-US/20f712e175191014907393741fadcb97.html) | SAP HANA on-premise | SAP HANA file system | CSV | |
5959
| [Insert into table name select from statement](https://help.sap.com/viewer/c1d3f60099654ecfb3fe36ac93c121bb/latest/en-US/20f7f70975191014a76da70c9181720e.html) | All | local or remote tables | select statement | |
6060

61-
The following steps will attempt to demonstrate an export and import of data from the maintenance table using the download option from the SQL Console and the import data wizard.
61+
The following steps will attempt to demonstrate an export and import of data from the maintenance table using the download option from the SQL console and the import data wizard.
6262

6363
1. Enter the SQL statement below.
6464

@@ -315,7 +315,7 @@ The following steps walk through the process of exporting to and importing data
315315

316316
Once complete, a JSON file will be downloaded that contains the `client_email` and `private_key` which will be used when accessing the bucket.
317317

318-
8. Remove any line breaks (i.e. \n) from the private key. This can be done by pasting the private key into a new SQL Console and opening the search and replace menu (Ctrl-F).
318+
8. Remove any line breaks (i.e. \n) from the private key. This can be done by pasting the private key into a new SQL console and opening the search and replace menu (Ctrl-F).
319319

320320
![Remove line breaks](remove-line-breaks.png)
321321

@@ -401,7 +401,7 @@ The following steps walk through the process of exporting to and importing data
401401
402402
Additional details can be found at [Certificate Management in SAP HANA Cloud](https://help.sap.com/viewer/c82f8d6a84c147f8b78bf6416dae7290/latest/en-US/1e6042c4402545f7a0574f7bc91fab25.html).
403403
404-
11. Run the following commands within the SQL Console to perform an export using a Google Cloud Storage bucket.
404+
11. Run the following commands within the SQL console to perform an export using a Google Cloud Storage bucket.
405405
406406
There are two ways to use the export commands as shown below.
407407
@@ -431,7 +431,7 @@ The following steps walk through the process of exporting to and importing data
431431
```
432432

433433

434-
14. Run the following commands within the SQL Console to perform an import using a Google Cloud Storage bucket.
434+
14. Run the following commands within the SQL console to perform an import using a Google Cloud Storage bucket.
435435

436436
```SQL
437437
--Uses the previously stored credential

‎tutorials/hana-dbx-extension/hana-dbx-extension.md‎

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -57,7 +57,7 @@ The SAP HANA database explorer extension can connect to SAP HANA Cloud and on-pr
5757

5858
2. Select **SAP HANA Cloud** as your database type and enter values for the **Host**, **Port**, **User** and **Password**, such as USER1 and Password1. You may also change the display name, as desired.
5959

60-
This tutorial uses the HOTEL schema. Set the default schema value in the **Advanced Options** as shown below. Subsequent SQL Consoles you open will now start with this schema value.
60+
This tutorial uses the HOTEL schema. Set the default schema value in the **Advanced Options** as shown below. Subsequent SQL consoles you open will now start with this schema value.
6161

6262
```Advanced Options Field
6363
currentSchema=HOTEL;
@@ -117,7 +117,7 @@ The SAP HANA database explorer extension also allows you to connect to the datab
117117
118118
Once logged in, you should see the database instances list from the web-based SAP HANA database explorer appear in your Database List. To open an SAP HANA SQL console in Visual Studio Code, hover over the connection and click the console icon.
119119
120-
![Cloud Foundry SQL Console](cfConsole.png)
120+
![Cloud Foundry SQL console](cfConsole.png)
121121
122122
To open the database in SAP HANA database explorer, click the stacked boxes icon.
123123
@@ -162,13 +162,13 @@ Learn how to change settings and leverage features such as split editor, layout
162162
163163
![DBX Settings](dbx-settings2.png)
164164
165-
3. Visual Studio Code also has built-in functionality that allows you to split editors which can be very useful to customize your workspace. For example, if you are working on multiple tasks, or need to refer to a table while manipulating another one, this feature can allow you to work more efficiently. In a SQL Console, run the following code.
165+
3. Visual Studio Code also has built-in functionality that allows you to split editors which can be very useful to customize your workspace. For example, if you are working on multiple tasks, or need to refer to a table while manipulating another one, this feature can allow you to work more efficiently. In a SQL console, run the following code.
166166
167167
```SQL
168168
SELECT * FROM CUSTOMER;
169169
```
170170
171-
Open another SQL Console, click the split editor icon, and then drag one of the SQL Console tabs into the new space to the right.
171+
Open another SQL console, click the split editor icon, and then drag one of the SQL console tabs into the new space to the right.
172172
173173
![Split Editor](splitEditors.png)
174174
@@ -234,7 +234,7 @@ The extension also allows you to import and export SQL files to and from your co
234234
235235
### Run SQL code
236236
237-
1. Open a new SQL Console and use the newly created function with the following code. Click on the dropdown arrow beside Run to view the different Run options. Then, normally **Run** your code.
237+
1. Open a new SQL console and use the newly created function with the following code. Click on the dropdown arrow beside Run to view the different Run options. Then, normally **Run** your code.
238238
239239
```SQL
240240
SELECT AVERAGE_RATING(1) FROM DUMMY;

0 commit comments

Comments
 (0)