This API allocates a statement handle.
1. Database connection: A database connection definition object returned by pjs.getDB(). If not passed, the default database connection is used.
The API returns a handle, which can be used again in other statements.
SQL diagnostics are reported in the SQLCA:
SQLCA fields are defined in Profound.js programs with the names in lowercase. sqlcode will be set to zero if execution was successful.
When using an IBM i database, this API requires the Profound.js Connector module.