Has anyone worked on a project where you have written a code with similar specifications writtten below? If yes, can you share your experience on how good or bad this is compared to the traditional approach of embedding the SQL directly in a module?
Lets assume that we have a table called EMPLOYEE. and an application written in COBOL.
Instead of embedding the SQL to access this table in every program that has to access this table, we create a sub-module that contains all the SQL statements against this table. So whenever there is a need to access this table, we just call the sub-module with enough input.