Hi,Here is an example of how you can do this:create procedure temp.add_leading_zeroslanguage SQLSCRIPT ASbegin update temp.person p set p.person_name = (select lpad(p1.person_name, 10, '0') from temp.person p1 where p.person_id = p1.person_id); ...
Hi Paolo,Here is an example procedure with your query:create procedure testlanguage SQLSCRIPT AS CardName varchar(100);begin select o.CardName into CardName from OCRD o WHERE CardCode = 'C20000' ; select :CardName as "CardName" from DUMMY;endRega...
Hi Moaz,Not that this will solve your problem but at least you will have the answer of your question about the restrictions. Check this : http://help.sap.com/hana/html/_isql_restrictions_for_sql_statements.htmlRegards,Yordan