About former_member631142

former_member631142

Hi Amer,If I understand your question, you can DISTINCT CLAUSE to get what you need. Refer below sample code.DO BEGIN IT_T = SELECT 'JOHN SMITH' as NAME, 10 as OBJECTS from dummy UNION ALL SELECT 'JOHN SMITH' as NAME, 10 as OBJECTS from dummy ; SE...

former_member631142

Hi Rajdeep,In procedure, for input parameter, you need to declare as table type instead of scalar input parameter. Refer below sample script:-PROCEDURE "your_procedure_name" ( IN IP_ORG_ID TABLE (ORG_ID VARCHAR(50)), IN IP_VERSION TABLE (VERSION VAR...

former_member631142

Hi Aakash,Please check in below two system views for column "IS_VALID". If value is FALSE then it is inactive object.select top 10 * from procedures; select top 10 * from functions;If you are ok with the answer then, accept the same.

former_member631142

Hi Siba,Yes, table funciton supports IF Else Control flow structure.Example: IF (:ip_input_param = '') OR (:ip_input_param IS NULL) THEN do this;ELSE do that;END IF;

former_member631142

Hi SibaCan you post your code to comment further on IF Else?

User Statistics

User Activity

Re: SAP hana View exclude aggregation

Re: SAP HANA stored procedure with multiple input parameter accepting multiple values

Re: How to get a list of invalidated procedures and functions in HANA Database?

Re: Table Function

Re: Table Function