Insertion relative to SQL processing in a Business Component

You can insert specific processing in the SQL clauses WHENEVER and DECLARE CURSOR. These clauses have a 10 hierarchical level. You must insert subfunctions in the specific function (level 05) that you attached to the FSQL block. In the created subfunctions, you can then insert subfunctions with a lower hierarchical level. It is advised to insert them in relative mode because they will be inserted in the subfunctions that depend on the SQL specific function.

SQL statements
Indicate the statement in which the specific processing is to be inserted:
  • WHENEVER SQL statement:

    In the Macro code, this specific processing is identified by REF=SQLW. In the Business Component code, it is identified by FSQL-WHENEVER

  • 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.

    In the Macro code, this specific processing is identified by REF=SQLD segm (where segm is the selected Segment or SQL view). In the Business Component code, it is identified by FSQL-CURSR-segm (where segm is the selected Segment or SQL view).

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 or SQL clause. The specific processing is inserted before the start tag of the standard processing.

    In the Macro code, the positioning of this specific processing is identified by ACTION=*A. In the Business Component code, it is identified by @BEFORE.

  • Insert after a standard processing or SQL clause. 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.

    In the Macro code, the positioning of this specific processing is identified by ACTION=*P. In the Business Component code, it is identified by @AFTER.

  • Replace a standard processing or SQL clause. This choice can be activated only if no specific subfunction has already been inserted in the SQL clause relatively to the attachment point (WHENEVER clause or DECLARE CURSOR clause on the same Segment). If a specific subfunction has already been inserted relatively to the attachment point, you must first remove it.

    In the Macro code, the positioning of this specific processing is identified by ACTION=*P. In the Business Component code, it is identified by @REPLACE.


Feedback