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 using code in a Profound.js program.
| Code Block |
|---|
| title | When Starting from an Interactive Terminal |
|---|
|
# SQL diagnostic information will display in the terminal window.
cd /profoundjs
PJS_SQL_DEBUG=1 node start.js |
| Code Block |
|---|
| language | javascript |
|---|
| title | Enabling Diagnostics Using Code in a Profound.js Program |
|---|
|
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.