Easytrieve Plus DB2 Styles and Standards

The following are styles and standards for Easytrieve Plus DB2:

Avoid SELECT * unless absolutely necessary
Avoid Control Input Processing
Automatic Input - SQL SELECT statement should follow JOB INPUT statement
System Version (named xxxVER) should always be the first program parameter on JCL. xxx is the system name (e.g., HRS, SIS).
NO INSERT, DELETE, UPDATE statements coded in EZ+ pgm's
Try to perform all condition checking via SQL statements (filter)
Avoid table JOINS with non-keyed columns
Use Sort and/or Sequence statement rather than the ORDER BY statement
Put DDL table name in INCLUDE members
New SELECT VIEW includes should be approved by Lead
Code one SELECT clause or subclause per line
When using table Correlation syntax - use four character ID names (e.g., EMRT is Employee Root Table) for Correlation naming convention.
If Controlled Processing can not be avoided, code it in a separate paragraph.
Use COMMIT only with Controlled Processing. It does not seem to work with Automatic Input.
Avoid using DEFER on Job Input statement
When using Correlation Syntax, use it consistently throughout your program
Add comment for tables that are used in your program in the program header
A FILE statement is not necessary for every table. Only use a FILE statement for the main input table.
Use a FILE DDName for your main input table that is the same as the short name of the table.

Last Modified: