DBILITY

급하게 짜깁기를 하였다. 프로시저와 함수는 INFORMATION_SCHEMA.ROUTINES를 조회한다. SELECT A.TABLE_NAME ,A.TABLE_TYPE ,B.VALUE AS DESCRIPTION FROM INFORMATION_SCHEMA.TABLES A LEFT OUTER JOIN ( SELECT OBJECT_ID(OBJNAME) TABLE_ID ,VALUE FROM::FN_LISTEXTENDEDPROPERTY(NULL, 'user', 'dbo', 'Table', NULL, NULL, NULL) ) B ON B.TABLE_ID = OBJECT_ID(A.TABLE_NAME) ORDER BY A.TABLE_NAME SELECT ROW_NUMBER() OVER (ORDER BY A.TABLE_N..

http://ibmsystemsmag.com/CMSTemplates/IBMSystemsMag/Print.aspx?path=/ibmi/administrator/db2/SQL-Arrays-in-DB2-for-i-7-1 언젠가 사용할 지 몰라 붙여뒀다. Historically, to pass a list of values to or from an SQL procedure, you'd had a few options Use a long list of input and output parameters. Over time, the procedure's parameter list can become unbearably long and difficult to understand. Concatenate all the v..

CREATE OR REPLACE PROCEDURE TEST_FILTER_INSERT (V_MSG out VARCHAR2) IS START_TIME NUMBER; END_TIME NUMBER; TX_CNT NUMBER; TX_INPROGRESS EXCEPTION; /****************************************************************************** NAME: TEST_FILTER_INSERT PURPOSE: 테스트 REVISIONS: Ver Date Author Description --------- ---------- --------------- ------------------------------------ 1.0 2016/09/27 ROOKI..