Reviewer always need some guidelines to review any kind of program. When you write a COBOL program and you send if for review, then, reviewer has a question in his mind that he will look for guidelines. Top 5 guidelines help you to review program written in SQL is very easy.
With checklist you can review SQL program quickly
Below is really a checklist for you and best practices to review SQL program. In general these are applied to any high level language like Java, C# etc. and not only COBOL.
- SQL Subquery with WHERE and Delete
- 8 Top SQL String Functions to Write Better Query
- DB2 SQL Query Performance Tuning (1 of 3)