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.
Code Block |
---|
language | bash |
---|
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 |
---|
|
// 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.