IFX_FOLDVIEW session environment option

Use the IFX_FOLDVIEW session environment option to enable or disable view folding for the currently executing routine.

The SET ENVIRONMENT IFX_FOLDVIEW statement of SQL supports the following syntax:

IFX_FOLDVIEW environment option  
|--SET ENVIRONMENT IFX_FOLDVIEW--+-'0'-------+----------------------|
                                 +-'OFF'-----+
                                 +-'1'-------+
                                 +-'ON'------+   
                                 '-DEFAULT---'

Usage

The IFX_FOLDVIEW environment option can override the settings of IFX_FOLDVIEW configuration parameter in the ONCONFIG file for enabling or disabling View Folding in the current session without affecting other user sessions.

'1' or "ON": Enables View Folding. During the current session, this setting overrides whatever values are set in IFX_FOLDVIEW configuration parameter.
'0' or "OFF": Disables View Folding. During the current session, this setting overrides whatever values are set in IFX_FOLDVIEW configuration parameter.
DEFAULT: This keyword restores the system default value, as described in the IFX_FOLDVIEW topic of the IBM® Informix® Guide to SQL: Reference

Important: For any other values, you will get the below error:

26041: Invalid values specified for the IFX_FOLDVIEW environment variable

Examples of enabling or disabling external directives

The following statement enables View Folding in subsequent queries executed in the current session:

SET ENVIRONMENT IFX_FOLDVIEW '1';

SET ENVIRONMENT IFX_FOLDVIEW "ON";

The following statement disables View Folding in subsequent queries executed in the current session:

SET ENVIRONMENT IFX_FOLDVIEW '0';

SET ENVIRONMENT IFX_FOLDVIEW "OFF";

Following statement will reset the IFX_FOLDVIEW set earlier (if done) and System default/Onconfig configuration will be restored.

SET ENVIRONMENT IFX_FOLDVIEW DEFAULT;