SUBALH9 processing: SUBALH9

AV_EXEREQ

This entry point is called before the extraction transaction of a query in the SUBALH9 processing.

It is used to initialize the variables in order to control the query running time.

Context and operating mode

In the context of the entry point :

• No trace file is open

NBB(1..10) contains the number of lines found by level.
CRITERE(250)(1..3) contains all the criteria applied to the linked tables.
The LISTE variable contains the query code.

The mask used in the transaction is called "WML" + the query code.

The automatic processing generated for a transaction is called "WMM" + the query code. In particular, it contains the detail of the tables used by the link and columns instruction.

AP_EXEREQ

This entry point is called after the extraction transaction of a query in the SUBALH9 processing.

It is used to display the query result by using the variables declared in the AV_EXEREQ entry point.

Context and operating mode

In the context of the entry point :

• No trace file is open

The variables and the different call cases are the same as those for the AV_EXEREQ entry point.

FILTER: Contains the criteria to filter the authorized sites

This entry point is called when creating criteria used to apply a filter to the main table.

It makes it possible to remove the filter on the authorized sites or to add an additional filter.
If the number of allowed sites is very large (>150), the "find" command sent out to the engine may be misinterpreted by the database. In that case, it is necessary to deactivate this find and use a 'func' command in the selection criteria of the query, for example.

Example: func ZZSITE.OKSITE([F:XXX]SITE)<>0

## ZZSITE Processing
Funprog OKSITE(SITE)
Value Char SITE
If find(site,GUSRFCY(1..GNBAUZ))<>0
 End 1
Endif
End 0

Context and operating mode

In the context of the entry point :

• No trace file is open

CRITERE(250)(1..3) contains all the criteria applied to the linked tables.
The LISTE variable contains the query code.
The FILTRE variable contains the formula used to filter the authorized sites.

The FILTER variable contains the Find(FCY,GUSRFCY(1..GNBAUZ)) instruction. The entry point is used to empty this variable or to modify its content before it is added in the CRITERE variable.

SET_UTIL: Contains the criteria to filter the authorized sites

This entry point is used to modify the user code used on the update transaction of the ALISTER table to avoid blocking problems under SQL-Server.

Context and operating mode

In the context of the entry point :

• No trace file is open

The UTIL variable contains the user ID.

WRITE_ALR: Avoiding the write in ALISTER

This entry point is used to avoid writing in the ALISTER table via the GPE variable.

In this case, the generation will be made directly in the entry point.

Context and operating mode

In the context of the entry point :

• No trace file is open

The GPE variable set to 1 is used to avoid writing in the ALISTER table.