SAP HANA存储过程样例（Table Type输出）

CREATE PROCEDURE getOutput( IN cnt INTEGER, IN currency VARCHAR(3), 
                            OUT output_pubs tt_publishers, 
                            OUT output_year tt_year) 
     LANGUAGE SQLSCRIPT READS SQL DATA AS 
BEGIN 
  big_pub_ids = SELECT publisher AS pid FROM books      -- Query Q1 
                GROUP BY publisher HAVING COUNT(isbn) > :cnt; 
  big_pub_books = SELECT title, name, publisher,        -- Query Q2 
                         year, price 
                  FROM :big_pub_ids, publishers, books 
                  WHERE pub_id = pid AND pub_id = publisher 
                  AND crcy = :currency; 
  output_pubs = SELECT publisher, name,                 -- Query Q3 
                       SUM(price) AS price, COUNT(title) AS cnt 
                FROM :big_pub_books GROUP BY publisher, name; 
  output_year = SELECT year, SUM(price) AS price,       -- Query Q4 
                COUNT(title) AS cnt 
                FROM :big_pub_books GROUP BY year; 
END;

 

 

标准存储过程创建语句：

CREATE PROCEDURE <proc_name> [(<parameter_clause>)] [LANGUAGE <lang>] [SQL SECURITY 
<mode>] 
[READS SQL DATA [WITH RESULT VIEW <view_name>]] AS 
<local_scalar_variables> 
BEGIN 
   <procedure_code> 
EN

专注于企业信息化，最近对股票数据分析较为感兴趣，可免费分享股票个股主力资金实时变化趋势分析工具，股票交流QQ群：457394862

分类:  SAP HANA

本文转自沧海-重庆博客园博客，原文链接：http://www.cnblogs.com/omygod/archive/2013/04/11/3015223.html，如需转载请自行联系原作者