I want to automate User Management task using Teradata Store Procedure and for that I have created one SP which will perform error checks like username length, presence of user in database before a user defined macro will insert new user record into user maintenance table.
I have used Cursor in this Procedure which will do row by row processing but I feel that this row by row processing can hamper performance because this process will be schedule to run very frequently.
Could you please suggest me an alternative apporoach which can be use instead of Cursors? And how can I use it in inside the SP?
Thanks in advance.