DSL構文
次のサンプルDSL構文を使用して、「rest/execute/v1/actions/ dsl/invoke」REST APIを実行して、sqlスクリプトプロシージャを作成、更新、および削除できます。プロシージャのサブタイプが「script」であるため、「script」という単語は主にDSL構文で使用されます。
DROP SCRIPT (IF EXISTS)? /path/name
———————————————————————————————————————————————————————————————
CREATE SCRIPT (IF NOT EXISTS)? /path/name
DEFINE AS script
(SET PROPERTIES {"name":{value}})?
(SET ANNOTATION 'this is a script created using DSL api' | NULL)?
———————————————————————————————————————————————————————————————
ALTER SCRIPT /path/name (RELOCATE AS /path/newName)?
(RELOCATE AS /newPath/newName)?
(DEFINE AS script)?
(SET PROPERTIES {"name":{value}})?
(SET ANNOTATION 'this is a script altered using DSL api' | NULL)?
———————————————————————————————————————————————————————————————
SELECT * FROM model.ALL_RESOURCE_PROPERTIES WHERE
PROPERTY_NAME = 'propName' AND
METADATA_ID =
(SELECT PROCEDURE_ID FROM model.ALL_PROCEDURES
WHERE PROCEDURE_NAME = 'name' AND //name of script
PARENT_PATH = '/path'); //parent path of the script