5 Understanding Table I/O Guidelines

This chapter contains the following topics:

• Section 5.1, "Table I/O Guidelines"

5.1 Table I/O Guidelines

Use these guidelines when you create table I/O functionality.

Ensure that you:

• Update the date,time,user, and program name when updating a table.

• Create a business function for each table to provide an API to retrieve, insert, delete, and update data from the table.

  For simple retrievals, insertions, deletions, and updates, use table I/O statements in Event Rules Design.

• Avoid updating a table with a business function from a different vertical than the vertical for the table.

  If a business function accesses multiple tables, limit the table I/O or API to the tables within same vertical as the business function. Ensure that a business function calls additional functions to retrieve data from other verticals.

See Also:

• "Understanding Events", "Event Rules", and "Runtime Processing" in theJD Edwards EnterpriseOne Tools Development Tools: Event Rules Guide .