Hana specific code to data

Question 1

Are keywords case sensitive in HANA native or Open SQL?

Answer 1

No

Question 2

In HANA native SQL are table and column names converted to uppercase?

Answer 2

Only if they are not enclosed in double quotes

Question 3

If I need to access a data source not defined in the ABAP data dictionary, what must I use?

Answer 3

HANA native SQL

Question 4

In HANA native SQL where must the element list be placed?

Answer 4

After the FROM clauses

Question 5

What is the source/field separator in HNSql?

Answer 5

a period

table.field

Question 6

What is the difference in Schema handling between HNSql and OSql?

Answer 6

HNSql uses the default implicit (user) schema or schema name before table name
OSql can only use the default schema

Question 7

In Hana Native SQL how is the client handled?

Answer 7

It must be specified, there is no implicit client handling

Question 8

What is the difference in the syntax of HNSql and OSql when it comes to limiting the number of rows selected?

Answer 8

In HNSql it is the keyword TOP
In OSql it is the phrase UP TO # ROWS
e.g
TOP 50
UP TO 50 ROWS

Question 9

Does HANA Native SQL have access to CDS views?

Answer 9

Yes and no, it won’t have access to the CDS as defined in the data dictionary but it will have access to the underlying SQL view created by the CDS

Question 10

What are two common Open SQL clauses that are not supported in HANA native SQL?

Answer 10

FOR ALL ENTRIES

CORRESPONDING FIELDS

Question 11

There is no syntax check for HANA Native SQL in ABAP. How can a syntax check be carried out?

Answer 11

In Eclipse, use SQL Console to test the statements

Question 12

What is difference between dats_days_between and days_between

Answer 12

the dats_ are used in open sql because dates are stored as numeric strings yyyymmdd
In hana dates are stored based on the sql standard of yyyy-mm-dd and can use standard sql functions like days_between

Question 13

What are the advantages of AMDPs?

Answer 13

AMDPs allow database procedures to be fully maintained and managed in ABAP.
All SQLscript syntax checking, debugging, transporting..

Question 14

How are AMDPs created?

Answer 14

As a method in a class where the method definition includes the keywords BY DATABASE PROCEDURE in the implementation.  This method then contains SQLscript instead of ABAP commands.
e.g.
METHOD my_method BY DATABASE PROCEDURE.
...sqlscript
...sqlscript
ENDMETHOD.

Question 15

If an AMDP method will be part of a class, what interface must be present in the public section of the class.

Answer 15

IF_AMDP_MARKER_HDB

Question 16

What types must be used for parameters of AMDP methods?

Answer 16

Scalar types. These are SQL-92 compliant types

Or table types with scalar columns

Question 17

AMPD methods can have all types of paramters;
Import
export
changing
returning?

Answer 17

No, returning is not available

Question 18

Parameters of AMDP can refer to ABAP dictionary structures as long as the structure only contains elementary components?

Answer 18

False. You cannot use ABAP dictionary structure type regardless of their components

Question 19

Table types can be used as parameters in AMDPs?

Answer 19

Yes, but the line of the table must be simple. Nothing nested is allowed. All fields must be scalar.

Question 20

Can the parameters of the AMDP have default values?

Answer 20

Yes

Question 21

The AMDP method must be in the public section of the class?

Answer 21

Incorrect, it can be public, protected, or private

Question 22

Write an example of method that calls a AMDP

Answer 22

Method my_amdp 
   BY DATABASE PROCEDURE
   FOR hdb
   LANGUAGE sqlscript
   OPTIONS read-only   -- not required
   USING bkpf vbak
...sqlscript starts here

Question 23

AMDP methods are instance methods?

Answer 23

Yes and no. They are defined in as methods, not class-methods, but they are executed as static methods

Question 24

If the AMPD uses ABAP tables or other objects, or calls other AMDPs, these must be listed in the USING clause of the method implementation

Answer 24

True

Question 25

SQLScript statements are ended with a...?

Answer 25

Semi-colon ;

Question 26

How are comments added in SQLScript?

Answer 26

two dashes -- | or a * in column 1

Question 27

In SQLScript, the host variables of SQL statements is escaped with .....

Answer 27

: a colon

Question 28

In SQLscript, there is no INTO addition for the select clause. How are records stored

Answer 28

``` The left hand side of the statement is the receiver structure or table. IT DOES NOT NEED TO BE DECLARED IN ADVANCE e.g. my_results = SELECT myfld1, myfld2 FROM thetable WHERE fld3 = :import_param ```

Question 29

In SQL script, how are system fields such as client accessed?

Answer 29

``` Using SESSION_CONTEXT('syfld') e.g. MANDT = SEESION_CONTEXT('CLIENT') ```

Question 30

within an AMPD, how would I call an existing AMPD?

Answer 30

Remember that even though they are defined as instance, they are global. So within a AMDP we would call an AMDP as CALL '{the class name the amdp is in}=>{ampd_method} e.g CALL "CL_BOB=>BOBS_AMDP( )"

Question 31

From ABAP, a AMDP is called like any other global method?

Answer 31

This is true | Call CL_CLASS=>METHOD( )

Question 32

AMDPs can be enhanced by...

Answer 32

A BADI if it was provided by the developer. In this case the BADI must be referenced in the USING clause of the BY DATABASE PROCEDURE clause

Question 33

What is ADBC used for?

Answer 33

Connecting to secondary databases

Question 34

What are the 7 steps of using an ADBC

Answer 34

1) Choose the database connection 2) Instantiate class CL_SQL_STATEMENT 3) Fill a string with the SQL 4) Call EXECUTE_QUERY of CL_SQL_STATEMENT 5) Assign a target variable for the result set calling CL_SQL_RESULT_SET method SET_PARAM or SET_PARAM_TABLE 6) Retrieve the result set calling CL_SQL_RESULT_SET method NEXT_PACKAGE 7) Close all by calling CL_SQL_RESULT_SET method CLOSE