I need to make a routine that can manage a database table with person's data with different fields: name, surname, return-code ecc.
The routine should be able to Insert, Delete, Select, Update fields in this DB2 table depending on the type of the letter user gives I, U, S, D ecc. But it should also be able to examine for eg. if all the fields are compiled for to be able to do an Insert in a table, or to delete to have at least one field with a value.
I would like to know, what should I define in a main program, what in a routine, do I need to use DCLGEN? Do I need to use a cursor? If I need to use a cursor or not?