New To DB2(First Day). Need help developing a SP to insert /update/delete a table record.
The procedure does the following.
1. Takes 2 parameters.
2. Should check for the user authentication to drop an existing procedure
3. Should check for the existence of the Object(Porcedure). If
<available> drop else <msg>
4. Insert the row into the coresponding table.
5. Should Capture Errors if any ?
I need syntax for my question or procedure structure of how to implement all the features in one procedure.