SQL Diagnostics
Setting environment variable PJS_SQL_DEBUG=1 causes the SQL API to output diagnostic information to standard output. PJS_SQL_DEBUG can be set either when starting the service or by using code in a Profound.js program.
When Starting from an Interactive Terminal
# SQL diagnostic information will display in the terminal window.
cd /profoundjs
PJS_SQL_DEBUG=1 node start.js
Enabling Diagnostics Using Code in a Profound.js Program
// Run this before calling any SQL API.
process.env["PJS_SQL_DEBUG"] = "1";
When starting Profound.js as a service on IBM i, the diagnostic information will be written to the instance standard output log in directory /profoundjs-base/INSTANCE_NAME/logs.
Some documentation pages have recently moved to a new section: Profound AppDev. If you are having trouble finding specific pages, try the documentation search capability or reach out to our Support team!