Purpose
The environment variable USE_LOCAL_CATALOG controls whether the StatementInformation parcel (flavor 169) includes local catalog information when communicating with databases that support Open Table Format (OTF) features. This variable provides runtime configuration without requiring changes to configuration file (clispb.dat).
Usage
USE_LOCAL_CATALOG=[Y|N]
- Y - Enable local catalog usage (include catalog information in database communications)
- N - Disable local catalog usage (default behavior)
Notes
- This environment variable takes precedence over the use_local_catalog setting in the configuration file (clispb.dat).
- Only effective when connecting to database systems that support OTF features.
- Invalid values will result in error BADUSELOCALCAT (604).
See Also
- Configuration parameter 'use_local_catalog' in The clispb.dat Listing
- DBCAREA field Use Local Catalog