system.db

Created by Paul Scott, last modified on Nov 08, 2021

Database Functions

The following functions give you access to view and modify data in the database.

In This Section ...

Functions by Scope

Gateway-scoped functions

Gateway Scope

Page:

system.db.addDatasource
Page:

system.db.beginNamedQueryTransaction
Page:

system.db.beginTransaction
Page:

system.db.clearAllNamedQueryCaches
Page:

system.db.clearNamedQueryCache
Page:

system.db.closeTransaction
Page:

system.db.commitTransaction
Page:

system.db.createSProcCall
Page:

system.db.dateFormat
Page:

system.db.execSProcCall
Page:

system.db.getConnectionInfo
Page:

system.db.getConnections
Page:

system.db.removeDatasource
Page:

system.db.rollbackTransaction
Page:

system.db.runNamedQuery
Page:

system.db.runPrepQuery
Page:

system.db.runPrepUpdate
Page:

system.db.runQuery
Page:

system.db.runScalarPrepQuery
Page:

system.db.runScalarQuery
Page:

system.db.runSFNamedQuery
Page:

system.db.runSFPrepUpdate
Page:

system.db.runSFUpdateQuery
Page:

system.db.runUpdateQuery
Page:

system.db.setDatasourceConnectURL
Page:

system.db.setDatasourceEnabled
Page:

system.db.setDatasourceMaxConnections

Vision-scoped functions

Vision Scope

Page:

system.db.addDatasource
Page:

system.db.beginTransaction
Page:

system.db.closeTransaction
Page:

system.db.commitTransaction
Page:

system.db.createSProcCall
Page:

system.db.dateFormat
Page:

system.db.execSProcCall
Page:

system.db.getConnectionInfo
Page:

system.db.getConnections
Page:

system.db.refresh
Page:

system.db.removeDatasource
Page:

system.db.rollbackTransaction
Page:

system.db.runNamedQuery
Page:

system.db.runPrepQuery
Page:

system.db.runPrepUpdate
Page:

system.db.runQuery
Page:

system.db.runScalarPrepQuery
Page:

system.db.runScalarQuery
Page:

system.db.runSFNamedQuery
Page:

system.db.runSFPrepUpdate
Page:

system.db.runSFUpdateQuery
Page:

system.db.runUpdateQuery
Page:

system.db.setDatasourceConnectURL
Page:

system.db.setDatasourceEnabled
Page:

system.db.setDatasourceMaxConnections

Perspective-scoped functions

Perspective Scope

Page:

system.db.addDatasource
Page:

system.db.beginNamedQueryTransaction
Page:

system.db.beginTransaction
Page:

system.db.clearAllNamedQueryCaches
Page:

system.db.closeTransaction
Page:

system.db.commitTransaction
Page:

system.db.createSProcCall
Page:

system.db.dateFormat
Page:

system.db.execSProcCall
Page:

system.db.getConnectionInfo
Page:

system.db.getConnections
Page:

system.db.removeDatasource
Page:

system.db.rollbackTransaction
Page:

system.db.runNamedQuery
Page:

system.db.runPrepQuery
Page:

system.db.runPrepUpdate
Page:

system.db.runQuery
Page:

system.db.runScalarPrepQuery
Page:

system.db.runScalarQuery
Page:

system.db.runSFNamedQuery
Page:

system.db.runSFPrepUpdate
Page:

system.db.runSFUpdateQuery
Page:

system.db.runUpdateQuery
Page:

system.db.setDatasourceConnectURL
Page:

system.db.setDatasourceEnabled
Page:

system.db.setDatasourceMaxConnections

No labels