Fetch the ;ast last record in the current table (by handle).
...
- message - The IBM i message text.
- error - The message id.
- help - The message help text.
Example
Code Block | ||
---|---|---|
| ||
c1 = pjs.allocStmt(); pjs.setStmtAttr(c1, SQL_ATTR_CURSOR_SCROLLABLE, SQL_TRUE); pjs.executeDirect(c1, "select prid from demolib/productsp order by prid"); pjs.fetchLast(c1, prid); pjs.close(c1); |
Requirements
This API requires the Profound.js Connector module.