keepColNameCase

For IBMi 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 as is, as resulted from the SQL statement; that is, do not lowercase the column names. The default value is false; that is, the column names are always in lowercase.

This configuration setting is available in Profound.js release 5.7.0. Prior to that release, the names of the columns in the result set are always in lowercase. Since release 5.7.0, you can use this configuration setting to override that behavior for the entire instance, or use API pjs.setOptions() to override that behavior for the current Profound.js session.

Note that this setting is in effect for the entire instance. If you have some current programs that rely on the fact the column names are always in lowercase, then setting this option to "true" could cause unexpected behavior in those programs. You may want to use API pjs.setOptions() to enable the new behavior at a session-level, for the current Profound.js session only.

Example

Click here for information on how to modify this setting.