Difference between Stored Procedure and Macro?
Answer:
SP:
It does not return rows to the user.
It has to use cursors to fetch multiple rows
It used Inout/Out to send values to user
It Contains comprehensive SPL
It is stored in DATABASE or USER PERM
A stored procedure also provides output/Input capabilities
Macros:
It returns set of rows to the user.
It is stored in DBC SPOOL space
A macro that allows only input values
No comments:
Post a Comment