Description

For the IBM i database, set this option to Boolean true to instruct pjs.query() and other SQL APIs to keep the case of column names in the result set exactly as the SQL statement produced them – that is, do not lowercase the column names. The default value is false, meaning column names are always returned in lowercase.

This configuration setting is available from Profound.js release 5.7.0. Before that release, result set column names were always lowercase. From 5.7.0 onward you can use this setting to override that behavior for the entire instance, or use pjs.setOptions() to override it for the current Profound.js session only.

This setting applies to the entire instance. If existing programs rely on column names always being lowercase, setting this option to true can cause unexpected behavior in them. Consider using pjs.setOptions() to enable the new behavior at session level instead.

Example

keepColNameCase: true

For information on how to modify this setting, see Configuration File.