SAP HANA Stuido中编写store procedure的语法与mysql中极为类似,并有多种方式调用之。
SAP HANA中store procedure的基本语法为:
CREATE PROCEDURE {schema.}name {({IN|OUT|INOUT} param_name data_type {,...})} {LANGUAGE <LANG>} {SQL SECURITY <MODE>} {READS SQL DATA {WITH RESULT VIEW <view_name>}} AS BEGIN END;
上述语法看上去挺吓人,其实并不难,下面的语法为HELL WORLD的程序:
CREATE PROCEDURE demo_proc_hello_world
LANGUAGE SQLSCRIPT AS
BEGIN
SELECT 'HELLO WORLD' FROM DUMMY;
END;
CALL demo_proc_hello_world;
从上面的代码中,可以使用CALL proc_name来调用procedure。还有另外一种方式可以调用,即:
DROP TABLE CUSTOMER;
CREATE COLUMN TABLE CUSTOMER(
CUST_ID VARCHAR(10),
AGE INTEGER
);
INSERT INTO CUSTOMER VALUES('Jim',10);
DROP PROCEDURE proWithResultView;
CREATE PROCEDURE