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
Read MoreConnect Hana with Java
Please see below code for getting hana kernel info and license info Please also search ‘ngdbc jar’ or use directly attached jar zipped ngdbc-2-3-58.jar import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; static void query_info(String ip, String port, String tename, String user, String password) { String perline = “”; Connection connection = null; String hostname […]
Read More