Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SAP Basis Articles
Page 32 of 50
Loading an individual column in SAP HANA using SQL
Yes, you can open SQL console and execute the statement −LOAD (, ...);This SQL query will load or unload entire column into or from main memory. Its load status is TRUE or FALSE. The table's load status is PARTIALLY.
Read MoreChanging Ownership of schema in SAP HANA Database
I don’t think you can change ownership of schema in database. Easiest way to change ownership of schema is by exporting a schema, drop it from the database and then recreate the schema owned by the target user and import the objects back into the database.In recent version, you can create schema and set other users as an owner of the schema however you can’t change it later −Create SCHEMA TEST123 owned by Demo;In same way, you can collect the script for "Create procedure" from database and drop the procedures in the earlier user schema and then these can be ...
Read MoreChecking SAP HANA Schema owner name
To check schema owner, you need access on “SYS” schema. Open SAP HANA SQL console and run the following SQL query −SELECT * FROM "SYS"."SCHEMAS";
Read MoreChecking schema creation in SAP HANA database
To check this detail, you should have access on “SYS” schema. Run the following SQL query and it will fetch the following columns −SELECT * FROM "SYS"."SCHEMAS";Schema_NameSchema_OwnerHAS_PRIVILEGESCreate_Time
Read MoreUsing Package specific default schema in SAP HANA
In SAP HANA, you can define package specific default schema as an authoring schema in your schema mapping definition and maintain it in the table M_PACKAGE_DEFAULT_SCHEMA.To perform this, navigate to SAP HANA Modeler perspective →; Maintain Package Specific Default SchemaSelect HANA system and it will show you schema names mapping as per package. You can maintain a default schema for each package. You can also add packages by clicking on Add button.
Read MoreSetting schema mapping in SAP HANA
Schema mapping in SAP HANA is used to move objects from one system to other system i.e. from Development system to Test or Test system to production system.To open schema mapping, navigate to SAP HANA Modeler → Schema Mapping → Select system you want to perform operationIn next window, you have to perform schema mapping between Authoring schema and physical schema.
Read MoreChecking authoring schema job details in SAP HANA
Go to Job log → Current and you can see last job ran for changing authoring schema. You can double click on job type to open the details. In job details, you can see status of job details.
Read MoreView to find object dependency in SAP HANA
In SAP HANA system, you have one view available in SAP System schema named called as “OBJECT_DEPENDENCIES”
Read MoreChecking list of all available schema in SAP HANA
This can be checked using below SQL query and it will display all the available schema in HANA system.select distinct BASE_SCHEMA_NAME from "SYS"."OBJECT_DEPENDENCIES"
Read MoreChecking list of system schema in SAP HANA
This can be checked using below SQL query and it will display all system schema in HANA system.select distinct BASE_SCHEMA_NAME from "SYS"."OBJECT_DEPENDENCIES" where BASE_SCHEMA_NAME like ‘_SYS%’;
Read More