HANA USAGE POINTS

1. client tool

DBeaver

2. sql code structure


-- when you need to run more commands.e.g insert/update etc
DO

BEGIN

DECLARE    var1 number;

DECLARE    var2 number;

--sql commands 

COMMIT;

END;

3. connect sql

CONNECT DBName PASSWORD dbpassword

4. dummy for sequence

select example_seq_name from dummy

Leave a Reply

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