SQL query tool - Implementation

Prerequisites

Authorizations

This function is object-managed, meaning that:

  • Creation, modification, and deletion operations can be activated or deactivated per user.

  • You can apply role-based filters to restrict access.

  • An access code filter is performed using the ACS field. If an access code is provided, the inquiry and modification rights are granted based on the read/write permissions associated with the current user's function profile.

Tables used

The following tables are implemented by the function:

Table

Table description

ACLOB [ACB]

Special folders

ALISTED [ALD]

Query tool

ALISTEH [ALH]

Query tool

ALISTER [ALR]

Query tool

AREPORTV [ARV]

Reports

ATEXTRA [AXX]

Texts to translate

ATYPE [ATY]

Data types

This function updates the following table that is shared across all folders, located in the supervisor:

Table

Table description

ABLBSYS [ASB]

Graphic components