Rational Programming Patterns

Insertion relative to SQL processing in a Business Component

You can create a subfunction to insert specific processing in the SQL clauses WHENEVER and DECLARE CURSOR. These clauses have a 10 hierarchical level.

SQL statements
Indicate the statement in which the specific processing is to be inserted:
  • WHENEVER SQL statement: This specific processing is identified by REF=SQLW in the Macro code.
  • DECLARE CURSOR SQL statement: If you select this statement, you must indicate the Table type Segment or the SQL view that contains the specific code to be taken into account. This specific processing is identified by REF=SQLD segm (where segm is the selected Segment or SQL view) in the Macro code.
Action type
Specific processing is inserted in a Business Component relatively to the standard generated processing. You can then benefit from the generated processing and adapt it to your needs.
You must select one of the following values to insert the specific processing:
  • Insert before a standard processing. The specific processing is inserted before the start tag of the standard processing. The positioning of this specific processing is identified by ACTION=*A in the Macro code.
  • Insert after a standard processing. The specific processing is inserted before the end tag if the hierarchical level is greater than the level of the standard processing. It is generated after the end tag if the hierarchical level is identical to the level of the standard processing. The positioning of this specific processing is identified by ACTION=*P in the Macro code.
  • Replace a standard processing. The positioning of this specific processing is identified by ACTION=*R in the Macro code.

Terms of use | Feedback

This information center is powered by Eclipse technology. (http://www.eclipse.org)