例: SHOW PROCEDURE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQLデータ定義言語 構文規則および例

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
2021年7月
Language
日本語
Last Update
2021-09-23
dita:mapPath
ja-JP/spp1591731285373.ditamap
dita:ditavalPath
ja-JP/wrg1590696035526.ditaval
dita:id
B035-1144
Product Category
Software
Teradata Vantage

次に、一例としてspSample1という名前のプロシージャのDDLを示します。

     SHOW PROCEDURE spSample1;
      *** Text of DDL statement returned.
      *** Total elapsed time was 1 second.
     -----------------------------------------------------------------
     CREATE PROCEDURE spSample1 (IN  ip INTEGER, 
                                 OUT op INTEGER) 
     BEGIN DECLARE var_1 INTEGER;
     SELECT col1 INTO var_1
     FROM tab_1
     WHERE col_2 = ip;
     SET op = var1 * 10;
     END;