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.
IT Applications Support
Last Modified: Tuesday, 28-Nov-2000 10:43:05 CST
©1999 All Rights Reserved