| 1 |
- window.repositoryObject = {"parameters_custom_fields":[],"object_id":"f369","name":"FN_GET_BIZDATE","subtype":"FUNCTION","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"style24@172.30.90.100","id":"d10"}},{"field":"Schema","value":""},{"field":"Name","value":"FN_GET_BIZDATE"},{"field":"Type","value":"Function"}],"script":"BEGIN\r\n\tDECLARE O_RET_VALUE VARCHAR(8);\r\n\r\n\tSELECT MAX(A.BIZDAY)\r\n\tINTO O_RET_VALUE\r\n\tFROM (SELECT BIZDAY\r\n\t\t FROM TB_BIZDAY\r\n\t\t WHERE BIZDAY > I_STDT\r\n\t\t\tAND BIZDAY_YN = 'Y' -- 영업일만\r\n\t\t LIMIT I_PERIOD\r\n\t\t) A\r\n\t;\r\n\r\n\tRETURN O_RET_VALUE;\r\nEND","parameters":[{"name":"Returns","description":null,"mode":"OUT","data_type":"varchar(8)","custom_fields":{}},{"name":"I_STDT","description":null,"mode":"IN","data_type":"varchar(8)","custom_fields":{}},{"name":"I_PERIOD","description":null,"mode":"IN","data_type":"int(10, 0)","custom_fields":{}}],"dependencies":null,"imported_at":"2021-11-11 16:37"};
|
