What is a reason to use SQL procedures in DB2?
A. to use different programming languages
B. to reduce code sharing
C. to move business logic rules into the database
D. to eliminate the need for testing
Which statement correctly describes characteristics of external functions?
A. External functions cannot return tables.
B. All cursors opened within an external function should stay open until thedatabase is quiesced.
C. Scratchpads can be used to allocate dynamic memory required for multiple function invocations.
D. Transactions can be terminated within external functions.