- Modes of Operation

There are two modes of operation that can be used to access an SQL database - Transparent mode and Full Function mode.

In Transparent mode, PROIV automatically generates the necessary SQL statements for SQL table data access/manipulation. The method of data access/manipulation is completely transparent to the application; it is controlled exclusively by PROIV within the normal Timing Cycle.
In Full Function mode, you can embed SQL statements within the logic of a PROIV Function. In the case of a SELECT statement which references a PROIV File Definition (in place of the normal SQL tablename), you have the flexibility to override the specific record(s) to be manipulated within the normal timing cycle, based upon criteria defined within the statement. It is important to note that the execution of such a SELECT is deferred until the normal point at which data is read within the PROIV Timing Cycle. Any other SQL statement is executed immediately, at the point it occurs within the PROIV Logic. It is also important to note that the use of the Full Function mode with Auto-Sequenced Files is not supported.

Section links:

Transparent Mode explains how to use Transparency mode.

Full Function Mode explains how to use Full Function mode.

Topic ID: 720143