- Mixed Transparency and Full Function Mode SELECTs

It is possible to mix Transparent mode and Full Function mode SELECTs on the same PROIV file as shown in the following example.

In Before-Read logic for file PRO4FILEB:

IF $TEMP='TEST'
SQL
   SELECT
   FROM PRO4FILEB
   WHERE KEY1 = :FILAVAR1
   AND VAR2 = 'TEST'
ENDSQL
ENDIF

If no Full Function mode SELECT has been encountered in the current iteration of the cycle or Report cycle, that is the value of $TEMP does not equal TEST, then the Transparency mode statement is used.

Comment on this topic

Topic ID: 720142